sql server2005 存储过程返回值问题

Question

sql serversql存储过程

Answer 1

CREATE PROC pr_Test
AS
BEGIN
    DECLARE @code  NVARCHAR(10)
    SET @code=N'0000123456'
    RETURN @code
END

Answer 2

本帖最后由 DBA_Huangzj 于 2014-03-18 16:35:19 编辑

  

Answer 3

CREATE PROC pr_Test
AS
BEGIN
DECLARE @code  NVARCHAR(10),@sql NVARCHAR(max)
SET @sql='select @code=''0000123456'''
EXEC sys.sp_executesql  @sql,N'@code  NVARCHAR(10) OUTPUT',@code OUTPUT
SELECT @code
ENDgo
EXEC pr_Test go