How to define array variable in store procedure

Hi Vijay,


Please refer below link. i hope it will help you.

http://weblogs.sqlteam.com/jeffs/archive/2007/06/26/passing-an-array-or-table-parameter-to-a-stored-procedure.aspx


Thanks.

Vijay,
There is no array datatype in sql server and as a work around you can use temp table or table level variable to store list of records.