Getting the Id of a row I updated in Sql Server

by

The @@identity and scope_identity() will hand you the identity of a new row, ie. after an insert. After your update, the identity of the row is… @Customer_ID or @Handle_Id? If it is a different field, you should use the OUTPUT clause to return the ID of the updated row:

UPDATE ITS2_UserNames  
SET AupIp = @AupIp  
OUTPUT INSERTED.PrimaryKeyID
WHERE @Customer_ID = TCID AND @Handle_ID = ID

More Related Contents:

  1. How do I UPDATE from a SELECT in SQL Server?
  2. How to calculate age (in years) based on Date of Birth and getDate()
  3. CROSS JOIN vs INNER JOIN in SQL
  4. INNER JOIN vs LEFT JOIN performance in SQL Server
  5. Function vs. Stored Procedure in SQL Server
  6. How to get difference between two rows for a column field?
  7. Counting DISTINCT over multiple columns
  8. SQL Server 2008: how do I grant privileges to a username?
  9. SQL Server SELECT into existing table
  10. How to check if a stored procedure exists before creating it
  11. Insert Into… Merge… Select (SQL Server)
  12. The parameterized query expects the parameter which was not supplied
  13. SQL Server: drop table cascade equivalent?
  14. SQL Server converting varbinary to string
  15. SSIS Source Format Implicit Conversion for Datetime
  16. How do I prevent a database trigger from recursing?
  17. SQL Server Operating system error 5: “5(Access is denied.)”
  18. How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query
  19. UNION the results of multiple stored procedures
  20. How to pass a temp table as a parameter into a separate stored procedure
  21. Finding a Top Level Parent in SQL
  22. SQL Server Cumulative Sum by Group
  23. SQL Server FOR XML Path make repeating nodes
  24. SQL – How do I get only the numbers after the decimal?
  25. How to retrieve records for last 30 minutes in MS SQL?
  26. Group consecutive rows of same value using time spans
  27. Connecting to Oracle Database using Sql Server Integration Services
  28. Why do SQL Server Scalar-valued functions get slower?
  29. Executing SQL query on multiple databases
  30. SQL add filter only if a variable is not null

Leave a Comment