sql insert binary data

Question

I am using sql server r2 2008

i want to insert a binary data using a query

i tried this

INSERT INTO dbo.[User]
(GSM, SIM, [Password], SessionID, [type])
VALUES
("1", "1", "1", "1", '0x00')

but i got an error in the "0x00"

what should i do please?

This is the error

Msg 207, Level 16, State 1, Line 1
Invalid column name '1'.
Msg 207, Level 16, State 1, Line 1
Invalid column name '1'.
Msg 207, Level 16, State 1, Line 1
Invalid column name '1'.
Msg 207, Level 16, State 1, Line 1
Invalid column name '1'.

@PeterRing when i did your soluton, i got the error that i put in the questoni — user2059935
– user2059935, Commented Feb 3, 2014 at 13:10
@AlexK. when i did your solution, i got the error that i put in the question, — user2059935
– user2059935, Commented Feb 3, 2014 at 13:10

PeterRing · Accepted Answer · 2014-02-03 13:10:28Z

3

Dont need ''.

INSERT INTO dbo.[User]
(GSM, SIM, [Password], SessionID, [type])
VALUES
('1', '1', '1', '1', 0x00)

answered Feb 3, 2014 at 13:10

PeterRing

1,81713 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2059935 Over a year ago

+1 to you, i will accept your answer after 8 minutes

pankeel · Accepted Answer · 2014-02-03 13:09:26Z

0

like this..

INSERT INTO
    [MyDatabase].[dbo].[tblPicture]
    ( Name, Branch, Age, Image )

    (
        SELECT 'a','amd',1,*
        FROM OPENROWSET
            (BULK N'c:\image.jpg', SINGLE_BLOB)
        AS Picture
    )

answered Feb 3, 2014 at 13:09

pankeel

1,1331 gold badge10 silver badges22 bronze badges

Collectives™ on Stack Overflow

sql insert binary data

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related