declare @ table a custom type, @ table 2 custom types, @ difference set custom typedirectly execute the select * from table 1 EXCEPT the select * from @ @ table 2
Select @ difference set=select * from table one EXCEPT the select * from @ table 2 @
Don't make a mistake, but wants to give the assignment to another variable is prompt error, could you tell me how to change the format to,