Re: Error on INSERT Query

Are you trying to insert via a stored procedure, or a simple insert
statement?

Try delimiting the string with single quotes. As in:

INSERT INTO YourTable (YourColumn) VALUES
('489d68bf-baa1-415d-94c7-a8e56b-609c61')


Replace YourTable and YourColumn with whatever is appropriate

--
Keith Kratochvil


"Vijay" <Vijay@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:233A3D0E-1A73-424A-BB00-608D9676247B@xxxxxxxxxxxxxxxx
I want to insert "489d68bf-baa1-415d-94c7-a8e56b-609c61" in a column in sql
server . The data type of this column is varchar (100). i am getting the
folloing error - incorrect syntax near '68bf'. I think it is not accepting
the '-'. How can i get a work around for the '-' so that the above values
gets inserted successfully.


.

Loading