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?
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
)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With