How to define array variable in store procedure

Question

Hi How to define and declare array variable in store procedure.

Aarti · Answer

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.

Muralidharan Deenathayalan · Answer

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.

Suthish Nair · Answer

Simple creating and storing in a TABLE. Its equivalent for array :)