Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Hi All:
I am trying to update one of the filed in my sql table. I need to update only one row in this table.
this is my code
Set RowCount 1
Declare @ActID Varchar(15)
Declare @TranAmt Money
Declare TableCursor Cursor For
Select Activity_ID,Tran_Amt From QW2_ROLLUP_TABLE GROUP BY ACTIVITY_ID, TRAN_AMT
Open TableCursor
Fetch Next From TableCursor into @ActID,@TranAmt
While @@Fetch_Status = 0
Begin
UPDATE QW2_ROLLUP_TABLE
SET New_Tran_Amt = @TranAmt
Where Activity_ID = @ActID
End
Close TableCursor
Deallocate TableCursor
When this finish executing, none of the row in this table is updated. Please tell me what am I doing wrong?
Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement