passing multiple id with comma to sql and get values ...

Posted by Gopal_nivas under ASP.NET on 2/7/2011 | Points: 10 | Views : 2612 | Status : [Member] | Replies : 2
hi..

i have passed multiple id values with comma separated like this 2,3,11 using stored procedure..

here i want to get the details of these three id's.

how to split and pass the id and how to get all id values at
the same time..

i know using spliting in sql we can achieve this.
but how to do this..

need ur suggestions with examples..




Responses

Posted by: Sathya4260 on: 2/7/2011 [Member] Starter | Points: 25

Up
0
Down
Can you explain ur point of view clearly...

Sathish Kumar S

Gopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Karthikanbarasan on: 2/7/2011 [Member] [Moderator] [Microsoft_MVP] [MVP] Silver | Points: 25

Up
0
Down
Hi,

Check this link

http://www.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx

Thanks
Karthik
www.f5Debug.net

Gopal_nivas, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response