I need to access array in SQL Server while using insert command.
@slted has values like (1,2,3) these value is used to insert the no. of rows
alter proc usp_sltedAssign
@slted nvarchar, @curentMenuID bigint
as begin
insert into Table301 (FLD119,FLD232,FLD9)
values('1', @curentMenuID, @slted)
end
Create your array as an xml string, the use the XML functionality within SQL to parse out and insert into a table- or what ever you want to do
The question is not very precise, but you might find what you're looking for by using TVPs.
Basically you can pass complete tables as parameters to queries, and then use them like normal table variables.
