I want to use a simple except statement in my stored procedure. But got error
DECLARE SAME INT;
SELECT 1 INTO SAME
SELECT ND
FROM MYTABLE
WHERE ID = 1
EXCEPT
SELECT ND
FROM MYTABLE
WHERE ID = 2
I want to use a simple except statement in my stored procedure. But got error
DECLARE SAME INT;
SELECT 1 INTO SAME
SELECT ND
FROM MYTABLE
WHERE ID = 1
EXCEPT
SELECT ND
FROM MYTABLE
WHERE ID = 2