存储过程怎么返回数值？

Question

不可以写
SELECT  @SurveyId_1 = SurveyId 
from T_Trace_Survey
where CaseId = @CaseId_3

Answer 1

没问题你EXEC时带了outputkcg ???

Answer 2

没问题你EXEC时带了output吗？？

Answer 3

完整写法
CREATE PROCEDURE [insert_T_Trace_Survey_1]
(@SurveyMemberId_2  [smallint],
 @CaseId_3  [smallint],
 @UniformId_4  [char](20),
 @SurveyDate_5  [datetime],
 @SurveyTimeSpan_6  [char](4),
 @SketchFile_7  [varchar](250),
 @SurveyNotesFile_8  [varchar](250),
 @SurveyAnlysisFile_9  [varchar](250),
@SurveyId_1  [int]  OUTPUT)

AS 
INSERT INTO [spyMis].[dbo].[T_Trace_Survey] 
 ( [SurveyMemberId],
 [CaseId],
 [UniformId],
 [SurveyDate],
 [SurveyTimeSpan],
 [SketchFile],
 [SurveyNotesFile],
 [SurveyAnlysisFile]) 
 
VALUES 
(  @SurveyMemberId_2,
 @CaseId_3,
 @UniformId_4,
 @SurveyDate_5,
 @SurveyTimeSpan_6,
 @SketchFile_7,
 @SurveyNotesFile_8,
 @SurveyAnlysisFile_9)SET @SurveyId_1=@@IDENTITY

Answer 4

CREATE PROCEDURE [insert_T_Trace_Survey_1]
(@SurveyMemberId_2  [smallint],
 @CaseId_3  [smallint],
 @UniformId_4  [char](20),
 @SurveyDate_5  [datetime],
 @SurveyTimeSpan_6  [char](4),
 @SketchFile_7  [varchar](250),
 @SurveyNotesFile_8  [varchar](250),
 @SurveyAnlysisFile_9  [varchar](250),
@SurveyId_1  [int]  OUTPUT)

AS 
set nocount on
declare @rc int
select @rc =0begin tran insert_data
if @rc=0
begin
INSERT INTO [spyMis].[dbo].[T_Trace_Survey] 
 ( [SurveyMemberId],
 [CaseId],
 [UniformId],
 [SurveyDate],
 [SurveyTimeSpan],
 [SketchFile],
 [SurveyNotesFile],
 [SurveyAnlysisFile]) 
 
VALUES 
(  @SurveyMemberId_2,
 @CaseId_3,
 @UniformId_4,
 @SurveyDate_5,
 @SurveyTimeSpan_6,
 @SketchFile_7,
 @SurveyNotesFile_8,
 @SurveyAnlysisFile_9)end
select @rc=@@error
if @rc<>0
begin
  select @rc=-1
  rollback tran insert_data
          return @rc
        end
else
       commit tran insert_dataselect @SurveyId_1 =@@identity
go