Using SQL server 2012 and Management Studio, I have a variable that currently states:
declare @OutputList Support.RollbackOutputList
I want to add a schema in front, so I tried to add the database name at the start (DB1) so it reads @OutputList DB1.Support.RollbackOutputList.
However it gives me an error stating:
Parameter or variable @OutputList has an invalid data type.
Now the Support.RollbackOutputList is actually a user defined table which can be viewed in the object explorer if you select the:
Database > Programmability > Types > User Defined Table Types and it's there.
How can I call upon this table using the database schema?
have a line like this before the current statement
USE DB1
GO
DECLARE @OutputList Support.RollbackOutputList
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