Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Insert data by passing the data through a paramete

Author  Topic  rajusvs Starting Member 9 Posts Posted - 2001-09-13 : 15:22:13 Hi, I want to insert data in a table(more than one col's)by passing the data as string delimited by ',' or '|'. Is there any way i can do this. here are the details. Table xyz col1 char(50) col2 char(50) col3 char(50) data string: 'This data is for col1|'This data is for col2|'This data is for first col3\n This data is for col1|'This data is for col2|'This data is for first col3' I am planning to create a stored procedure and pass this data as a string. thanks Raj