Pass Array Values To Stored Procs
Posted on 2006-04-11
Im converting one of our applcations to vb.net , the old app uses in line T-SQL to build its qeuries and then run it against SQL database. One of these functions uses a select statement with the IN clause example: Select * from [Table] where [Field] In (value,value2,value3........
How do i convert this to using a stored procedure. Can i pass the comma seperated values as a parameter and then exec the query?
thanks in advance!