Transact-SQL array)

Article Source: http://dev.csdn.net/article/81737.shtm
The data structure like an array needs to be used in SQL Server. However, there is no built-in array in transact-SQL. I heard that it can be implemented using strings in combination with a temporary table. I tried it myself. The solution is as follows: Create   Proc   [ DBO ] . [ Createarray ]
@ String   Varchar ( 1024 )
As
Create   Table # Array (ID Int   Identity , Value Varchar ( 32 ))
Set   @ String = ' Insert # array select ''' + Replace ( @ String , ' , ' , ''' As STR Union all select ''' ) + ''''
Exec ( @ String )
Select   *   From # Array

Go

Run the following command:

Exec Createarray ' Cchess, dig, gobang, landlord, majiang '