CREATE PROCEDURE sp_selectTABLE1 @varA VarChar (10) = 'lxl' AS Declare @UserID int Declare @UserName VarChar (20) Declare TestCursor Cursor For Select * from TABLE1 For Update Of UserName Open TestCursor While (0 = 0) Begin Fetch Next From TestCursor Into @UserID,@FieldA If (@@Fetch_Status = 0 ) Begin If (@UserID = 3) Begin Set @FieldA = @FieldA + @varA Update TABLE1 Set FieldA = @FieldA Where Current Of TestCursor End End
Else If (@@Fetch_Status <>0) Break End Close TestCursor Deallocate TestCursor GO
create procedure yourPro @vara varchar(100) asupdate yourTable set FieldA= FieldA + @vara where ......
@varA VarChar (10) = 'lxl'
AS
Declare @UserID int
Declare @UserName VarChar (20)
Declare TestCursor Cursor For
Select * from TABLE1
For Update Of UserName
Open TestCursor
While (0 = 0)
Begin
Fetch Next
From TestCursor
Into @UserID,@FieldA
If (@@Fetch_Status = 0 )
Begin
If (@UserID = 3) Begin
Set @FieldA = @FieldA + @varA Update TABLE1 Set FieldA = @FieldA Where Current Of TestCursor
End
End
Else If (@@Fetch_Status <>0) Break
End
Close TestCursor
Deallocate TestCursor
GO
@vara varchar(100)
asupdate yourTable
set FieldA= FieldA + @vara
where ......
在Insert Into语句里能实现吗?
update不是一样的吗??