Table valued parameters in SqlServer 2005
Posted on 2009-05-12
I want to use table type parameter for procedure because i need insert to to many rows(300000) quicly. This problem was solved in sqlserver 2008. I need like this code;
create proc(@tbl table(a int, b nvarchar(10))
insert into mytable(a,b)
select a,b from @tbl
i change this row like to:
create proc(@tbl myTableType)
How can i insert to many rows in a one transaction.
I'm use ado.net 1.1(asp.net) and sqlserver 2005.