twin.devil (12/10/2013)
As the User Define table Types are created as table-valued, so you cannot assign null to a table.2ndly if you want to check if there is any value in the variable then you can use the following:
Place the following code after the scope_identity()
IF EXISTS ( Select 1 from @skills)
Begin
-- Add your code here
End
Hope it helps.
I would like to check this for you, but I can't at the moment, but my gut feel is the same as twin.devil's. Basically you can't have a null table, but you can have an empty table