-- regular variable 100 row insert
declare @vint int,@vvarchar varchar(10),@vfloat float
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=33,@vvarchar='abcdefg',@vfloat=33.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=43,@vvarchar='abcdefg',@vfloat=43.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=53,@vvarchar='abcdefg',@vfloat=53.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=63,@vvarchar='abcdefg',@vfloat=63.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=73,@vvarchar='abcdefg',@vfloat=73.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=83,@vvarchar='abcdefg',@vfloat=83.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=93,@vvarchar='abcdefg',@vfloat=93.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=123,@vvarchar='abcdefg',@vfloat=123.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=223,@vvarchar='abcdefg',@vfloat=223.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=323,@vvarchar='abcdefg',@vfloat=323.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
select @vint=23,@vvarchar='abcdefg',@vfloat=3.34334
exec spInsertTest_regularvariable @vint,@vvarchar,@vfloat
go

-- table variable 100 row insert
declare @vtesttable test_1
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
insert into @vtesttable values (33,'abcdefg',33.34334)
insert into @vtesttable values (43,'abcdefg',43.34334)
insert into @vtesttable values (53,'abcdefg',53.34334)
insert into @vtesttable values (63,'abcdefg',63.34334)
insert into @vtesttable values (73,'abcdefg',73.34334)
insert into @vtesttable values (83,'abcdefg',83.34334)
insert into @vtesttable values (93,'abcdefg',93.34334)
insert into @vtesttable values (123,'abcdefg',123.34334)
insert into @vtesttable values (223,'abcdefg',223.34334)
insert into @vtesttable values (323,'abcdefg',323.34334)
insert into @vtesttable values (23,'abcdefg',3.34334)
exec spInsertTest_tablevariable @vtesttable
go