Home > database >  How to select * from table one EXCEPT the select * from table 2 @ assigned to another variable?
How to select * from table one EXCEPT the select * from table 2 @ assigned to another variable?

Time:03-04

 declare @ table a custom type, @ table 2 custom types, @ difference set custom type 
Select @ difference set=select * from table one EXCEPT the select * from @ table 2 @
directly execute the select * from table 1 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,
  • Related