createproc[dbo].[CreateArray] @stringvarchar(1024) as createtable #array (id intidentity,value varchar(32)) set@string=''''insert #array select ''''''''''''+replace(@string,'''','''',''''''''''''as str union all select '''''''''''')+'''''''''''''''' exec(@string) select*from #array go