Sorry i missed "not" in my last conversation... I am not able to insert records through the query i mentioned above.
Even i tried union all in last it did not worked.
akhush
Last Activity: Nov 4 '11, 06:08 PM
Joined: Nov 3 '11
Location:
-
Hi,
No I am able to insert multiple records as I mentioned earlier...Leave a comment:
-
Hi,
Thanks for replying me. However the checked by removing Ns still it is not working.Leave a comment:
-
Error in inserting multiple records
Hi,
I am getting error as below while inserting multiple records in table
Code : INSERT INTO Management.Depa rtments(Departm entCode, Name)
VALUES(N'ITEC', N'Information Technology'),
(N'PRSN', N'Personnel');
Error code : Msg 102, Level 15, State 1, Line 3 Incorrect syntax near ','.
My MS SQL server version is:-
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) ...
No activity results to display
Leave a comment: