October 29, 2008 at 4:46 am
I need to use the insert...set form in my code but the statement i have written is not working.
insert into contactinfo
set FullName='XYZ',
Source='ABC',
CreatedDate='2008-09-09 00:00:00.000',
ModifiedDate='2008-09-09 00:00:00.000'
Could anyone tell me if there is any syntactical error in the above statement? Is this syntax applicable for SqlServer 2005?
I m getting the following error:
Incorrect syntax near the keyword 'set'.
October 29, 2008 at 5:23 am
Pooja_prasad (10/29/2008)
I need to use the insert...set form in my code but the statement i have written is not working.insert into contactinfo
set FullName='XYZ',
Source='ABC',
CreatedDate='2008-09-09 00:00:00.000',
ModifiedDate='2008-09-09 00:00:00.000'
Could anyone tell me if there is any syntactical error in the above statement? Is this syntax applicable for SqlServer 2005?
I m getting the following error:
Incorrect syntax near the keyword 'set'.
Pooja,
Posting your question in 2 forums won't help you much, since most forum readers using the Active Threads anyway... This question already is answered!
Ronald
Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2
October 29, 2008 at 5:31 am
thnkz:-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply