code_junkie

I can read a binary field in MS SQL server 2005

Nov 11th, 2011
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. CREATE TABLE [dbo].[Table_1]([ID] INTEGER NOT NULL, [BIN] [binary](20) NULL);
  2. INSERT INTO table_1 values (1, cast('I am a binary field' as BINARY));
  3. SELECT ID, BIN, CAST(BIN AS VARCHAR(20)) AS BINTEXT FROM TABLE_1;
  4.  
  5. ID BIN BINTEXT
  6. ----------- ------------------------------------------ --------------------
  7. 1 0x4920616D20612062696E617279206669656C6400 I am a binary field
Add Comment
Please, Sign In to add comment