22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE sp_test
@NickName nvarchar(30) OUTPUT
WITH ENCRYPTION AS
BEGIN
SET NOCOUNT ON
SET @NickName = '哈哈哈哈'
--SELECT 1
SELECT 1 UNION SELECT 2
end
GO
declare @n nvarchar(30)
declare @r int
exec sp_test @n output
print @n
/*
-----------
1
2
哈哈哈哈