开发者

Does SQL Server 2008 have "stock" table parameter types?

开发者 https://www.devze.com 2023-01-22 16:10 出处:网络
Does SQL Server 2008 offer any pre-def开发者_StackOverflow中文版ined table types for use with table-valued parameters?

Does SQL Server 2008 offer any pre-def开发者_StackOverflow中文版ined table types for use with table-valued parameters?

For instance, if I just want to pass in a list of integers as a table, and derive necessary context from the other parameters I'm passing in, is there a type in place for that, or would I have to create it?


There are no system table types as far as I know. They are pretty easy to make though...

create type dbo.IntList as table (
  Value int not null
)
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号