摘要:
--定义一个数据类型create type userlist_tabletype as table( id int not null default 0, name varchar(50) not null default '')go--定义存储过程create proc dbo.pr_usetabletype @t userlist_tabletype readonlyas select * from @tgo--测试declare @tb userlist_tabletypeinsert into @tb (id,name) values (1,'henry' 阅读全文