添加一行数据便获取id,并在存储过程中使用
ALTER PROCEDURE [AddInfor] @ID int OUTPUT, @classid INT, @checkurl NVARCHAR(50), @headmanpwd NVARCHAR(50), @supervisorpwd NVARCHAR(50), @testpaperurl NVARCHAR(50), @wrongtimes INT AS BEGIN SET NOCOUNT ON DECLARE @Err int INSERT INTO TB_TestpaperDownload ( ClassID, CheckUrl, HeadmanPassword, SupervisorPassword, TestpaperUrl, WrongTimes ) VALUES ( @classid,@checkurl,@headmanpwd,@supervisorpwd,@testpaperurl,@wrongtimes ) SET @ID=SCOPE_IDENTITY() UPDATE TB_TestpaperDownload SET CheckUrl=(@checkurl+'?id='+convert(NVARCHAR(50),@ID)) WHERE ID=@ID END GO
在插入一行数据后,在这行数据的某一个字段上拼接上id