meitti
دوشنبه 14 مرداد 1387, 21:25 عصر
من يه StoreProcedure به صورت زير نوشتم براي گرفتن max فيلد مورد نظر كه براي گرفتن auto number مي خام از ان استفاده كنم
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[max_Id](int @t)
as
SELECT @t=MAX(Docr_Id) + 1
FROM Reg_Recive_Type
return @t
exec [max_Id]
كه error هاي زير را ميده
Msg 102, Level 15, State 1, Procedure max_Id, Line 2
Incorrect syntax near 'int'.
Msg 137, Level 15, State 1, Procedure max_Id, Line 4
Must declare the scalar variable "@t".
Msg 137, Level 15, State 2, Procedure max_Id, Line 7
Must declare the scalar variable "@t".
اگه ممكنه مشكل كار من را .........
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER proc [dbo].[max_Id](int @t)
as
SELECT @t=MAX(Docr_Id) + 1
FROM Reg_Recive_Type
return @t
exec [max_Id]
كه error هاي زير را ميده
Msg 102, Level 15, State 1, Procedure max_Id, Line 2
Incorrect syntax near 'int'.
Msg 137, Level 15, State 1, Procedure max_Id, Line 4
Must declare the scalar variable "@t".
Msg 137, Level 15, State 2, Procedure max_Id, Line 7
Must declare the scalar variable "@t".
اگه ممكنه مشكل كار من را .........