Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Does SQL Server 2008 offer any pre-defined 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?

like image 976
Matt Mills Avatar asked Oct 13 '22 22:10

Matt Mills


1 Answers

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
)
like image 73
MarkPflug Avatar answered Oct 18 '22 03:10

MarkPflug