SQL Server variable columns name?

by

You can’t do it because SQL is compiled before it knows what the value of @a is (I’m assuming in reality you would want @a to be some parameter and not hard coded like in your example).

Instead you can do this:

declare @a as varchar; 
set @a="TEST" 

declare @sql nvarchar(max)
set @sql="select [" + replace(@a, '''', '''''') + '] from x'

exec sp_executesql @sql

But be careful, this is a security vulnerability (sql-injection attacks) so shouldn’t be done if you can’t trust or well clean @a.

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. SQL server query to output the data shown below
  3. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  4. How do I generate a random number for each row in a T-SQL select?
  5. Select columns from result set of stored procedure
  6. Combine multiple results in a subquery into a single comma-separated value
  7. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  8. Floor a date in SQL server
  9. How to drop a table if it exists?
  10. Create a view with ORDER BY clause
  11. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  12. INSERT INTO vs SELECT INTO
  13. Possible to store value of one select column and use it for the next one?
  14. How FOR XML PATH(”) works when concatenating rows
  15. Scheduled run of stored procedure on SQL server
  16. SQL Server ORDER BY date and nulls last
  17. How can I do something like: USE @databaseName
  18. How to split string and insert values into table in SQL Server
  19. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  20. How can I get the sum of multiple datetime values?
  21. How do you change the datatype of a column in SQL Server?
  22. Use of Begin / End Blocks and the Go keyword in SQL Server?
  23. How do you determine what SQL Tables have an identity column programmatically
  24. Ampersand (&) operator in a SQL Server WHERE Clause
  25. Avg of float inconsistency
  26. how to write number to word function in sql server [closed]
  27. Is there an “IF EXISTS” test for a linked server?
  28. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  29. Does the `nodes()` method keep the document order?
  30. SQL Server stored procedure return code oddity

Leave a Comment