O administrador de dados do MJSP gerou uma Common Table Expression (CTE) em TSQL...

WITH salario_sup AS

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

)

SELECT * FROM salario_sup;

CURSOR salario_sup AS

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

);

SELECT INTO salario_sup

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

);

INSERT salario_sup

(

SELECT cargo, valor FROM SALARIO WHERE valor > 1000

);

SELECT cargo, valor

FROM SALARIO

WHERE valor > 1000;