hai all,

can any one teach me how to insert the string like below into sqlserver

'1001','1002','1003','1004','1005'

thanks

if you are inserting them into different columns then

1) Open the SQL Query Analyzer

2) use the following syntax

USE <dataBase_Name>
INSERT INTO <TABLE_NAME> (COLUMN_NAME1,COLUMN_NAME2,COLUMN_NAME3,COLUMN_NAM E4,COLUMN_NAME5) VALUES('1001','1002','1003','1004','1005')

3) Press F5

__________________
Vikash Kumar Singh

no, i trying to insert the string into 1 column, but the single quotes inside the string maked the query become a error

Hi Guys,

Do Like this.

Add two quotes ('') insted of single quotes(') at each place in input
string. And this string will also take in single quoted.

Your original String is :
'1001','1002','1003','1004','1005'

you have to change in this format
  '''1001'',''1002'',''1003'',''1004'',''1005'''

Try This.
Best of luck.