Dynamic update statement with variable column names

by

You can pass the name of the column in dynamic sql:

declare @sql nvarchar (1000);
set @sql = N'update table set ' + @column_name + '= ''''';

exec sp_executesql @sql;

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. How to create a specific SQL Server stored procedure? [closed]
  3. SQL Server – Best way to get identity of inserted row?
  4. Should I use != or for not equal in T-SQL?
  5. How to update two tables in one statement in SQL Server 2005?
  6. Create a date from day month and year with T-SQL
  7. How should I pass a table name into a stored proc?
  8. Is the NOLOCK (Sql Server hint) bad practice?
  9. Creating an index on a table variable
  10. OR is not supported with CASE Statement in SQL Server
  11. Parse comma-separated string to make IN List of strings in the Where clause
  12. SELECT FOR UPDATE with SQL Server
  13. Compare DATETIME and DATE ignoring time portion
  14. T-SQL: Selecting Column Based on MAX(Other Column)
  15. How to select only the first rows for each unique value of a column?
  16. How to store image in SQL Server database tables column [duplicate]
  17. SQL “between” not inclusive
  18. Can I set ignore_dup_key on for a primary key?
  19. Unordered results in SQL
  20. SQL Server replace, remove all after certain character
  21. How to find column names for all tables in all databases in SQL Server
  22. Inserting rows into a table with one IDENTITY column only [duplicate]
  23. SQL Row_Number() function in Where Clause
  24. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  25. When using GETDATE() in many places, is it better to use a variable?
  26. How do I compare 2 rows from the same table (SQL Server)?
  27. SQL Server SELECT INTO @variable?
  28. Select a column if other column is null
  29. Date serial in SQL?
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment