The following code is an illustration of how to use strongly typed table variable.
1. create type
create type typ as table (id int);
2. create table
create table temp(id int not null)
3. create procedure
create procedure myproc
@t typ readonly
as
insert into temp
select * from @t typ
4. run
declare @mytype typ
insert into @mytype values(1), (2), (3)
exec myproc @mytype
No comments:
Post a Comment