在存储过程这边的效果是一样的只是OUTPUT 还有另外一个用途 USE TEMPDB GO IF OBJECT_ID('TB')IS NOT NULL DROP TABLE TB GO ;WITH [CTE](A)AS( SELECT'1' ) SELECT * INTO TB FROM CTEDELETE FROM TB OUTPUT DELETED.A你可以体验一下
感谢楼上全部前辈,确定一样吗,帮助里 [ OUT | OUTPUT ]并列的啊CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter [ type_schema_name. ] data_type } [ VARYING ] [ = default ] [ OUT | OUTPUT ] [READONLY] ] [ ,...n ] [ WITH <procedure_option> [ ,...n ] ] [ FOR REPLICATION ] AS { <sql_statement> [;][ ...n ] | <method_specifier> } [;] <procedure_option> ::= [ ENCRYPTION ] [ RECOMPILE ] [ EXECUTE AS Clause ]<sql_statement> ::= { [ BEGIN ] statements [ END ] }<method_specifier> ::= EXTERNAL NAME assembly_name.class_name.method_name
USE TEMPDB
GO
IF OBJECT_ID('TB')IS NOT NULL
DROP TABLE TB
GO
;WITH [CTE](A)AS(
SELECT'1'
)
SELECT * INTO TB FROM CTEDELETE FROM TB
OUTPUT DELETED.A你可以体验一下
[ { @parameter [ type_schema_name. ] data_type }
[ VARYING ] [ = default ] [ OUT | OUTPUT ] [READONLY]
] [ ,...n ]
[ WITH <procedure_option> [ ,...n ] ]
[ FOR REPLICATION ]
AS { <sql_statement> [;][ ...n ] | <method_specifier> }
[;]
<procedure_option> ::=
[ ENCRYPTION ]
[ RECOMPILE ]
[ EXECUTE AS Clause ]<sql_statement> ::=
{ [ BEGIN ] statements [ END ] }<method_specifier> ::=
EXTERNAL NAME assembly_name.class_name.method_name