SQL: Update a row and returning a column value with 1 query

You want the OUTPUT clause

UPDATE Items SET Clicks = Clicks + 1
OUTPUT INSERTED.Name
WHERE Id = @Id

Related Contents:

  1. Use of SqlParameter in SQL LIKE clause not working
  2. WHERE IN (array of IDs)
  3. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  4. How to pass an array into a SQL Server stored procedure
  5. Call a stored procedure with parameter in c#
  6. Insert 2 million rows into SQL Server quickly
  7. Calling stored procedure with return value
  8. Remove weird characters ( A with hat) from SQL Server varchar column
  9. How do I return multiple result sets with SqlCommand?
  10. Return value from SQL Server Insert command using c#
  11. How to pass sqlparameter to IN()? [duplicate]
  12. What represents a double in sql server?
  13. Passing List to SQL Stored Procedure
  14. SqlConnection SqlCommand SqlDataReader IDisposable
  15. SqlBulkCopy from a List
  16. SQL command INSERT is working but the data not appear in table
  17. SQL error: Incorrect syntax near the keyword ‘User’
  18. ado.net Closing Connection when using “using” statement
  19. Connection timeout for SQL server
  20. MultipleActiveResultSets=True or multiple connections?
  21. How to give ADO.NET Parameters
  22. Using SqlDataAdapter to insert a row
  23. How to run multiple SQL commands in a single SQL connection?
  24. How can I retrieve a list of parameters from a stored procedure in SQL Server
  25. What size do you use for varchar(MAX) in your parameter declaration?
  26. Creating a SQL Server table from a C# datatable
  27. Generate class from database table
  28. Add WHERE clauses to SQL dynamically / programmatically
  29. Pass Array Parameter in SqlCommand
  30. Execute Insert command and return inserted Id in Sql
  31. Execute a large SQL script (with GO commands)
  32. How to monitor SQL Server table changes by using c#?
  33. C# Equivalent of SQL Server DataTypes
  34. OleDbCommand parameters order and priority
  35. Adding multiple parameterized variables to a database in c#
  36. How can I insert 10 million records in the shortest time possible?
  37. Invalid attempt to read when no data is present
  38. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  39. How to execute an SSIS package from .NET?
  40. SqlBulkCopy Insert with Identity Column
  41. What’s better: DataSet or DataReader?
  42. How to deploy application with sql server database on clients
  43. How to insert a data table into SQL Server database table?
  44. Is there any difference between DateTime in c# and DateTime in SQL server?
  45. Can’t access my SQL Server via C# form application from client device
  46. SQLException : String or binary data would be truncated
  47. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  48. Is there an Entity Framework 7 Database-First POCO Generator?
  49. Reverse engineering SSIS package using C#
  50. When executing a stored procedure, what is the benefit of using CommandType.StoredProcedure versus using CommandType.Text?

Leave a Comment