I am playing with tabletypes and it seems you can only use this for passing tabledata to a stored procedure. It would be nice if a tabletype can be used as a template for tables like:
However this gives an error. Am I missing something? If this would work, SQL will become a little more object-oriented :)
asked May 03, 2012 at 11:20 AM in Default
Wilfred van Dijk
You can use the type to declare a table variable though. And then use that to make a table using SELECT INTO...
drop table Enum_valuta