CREATE PROCEDURE testPro
AS
BEGIN
DECLARE @c nvarchar(3)
SET @c = '001'
PRINT @c
RETURN @c
ENDDECLARE @n NVARCHAR(3)
EXEC @n = testPro
PRINT @n返回值是1，实际上应该是‘001’，为什么？
CREATE PROCEDURE testPro
AS
BEGIN
DECLARE @c nvarchar(3)
SET @c = '001'
PRINT @c
RETURN @c
ENDDECLARE @n NVARCHAR(3)
EXEC @n = testPro
PRINT @n返回值是1，实际上应该是‘001’，为什么？
AS
BEGIN
SET @c = '001'
PRINT @c
RETURN @c
ENDDECLARE @n NVARCHAR(3)
EXEC testPro @n output
PRINT @n
你的需求可以用output来做
或者取到到数值之后再做格式化