Comma Seperated Values Insertion In SQL server 2005
Posted
by Asim Sajjad
on Stack Overflow
See other posts from Stack Overflow
or by Asim Sajjad
Published on 2010-04-08T04:38:12Z
Indexed on
2010/04/08
4:43 UTC
Read the original article
Hit count: 397
sql-server-2005
|sql
How can I insert Values from the comma separated input paramater to the Store prodcedure ? Example is
exec StopreProcedure Name 17,'127,204,110,198',7,'162,170,163,170'
you can see that I have two Comma Separated Values in the parameter list , both will have same number of values if first have 5 comma seperated value then second one also has 5 comma separated values you can says
127 and 162 are related 204 and 170 are related and same for other how can I insert these two values in ? One comma Sepated value is inserted but how to insert two ?
© Stack Overflow or respective owner
