Using a variable for table name in ‘From’ clause in SQL Server 2008

by 
SET @SQL = 'SELECT * FROM ' + @table
EXEC (@SQL)  -- parentheses are required

More Related Contents:

  1. Using “GO” within a transaction
  2. What’s a good way to trim all whitespace characters from a string in T-SQL without UDF and without CLR?
  3. Does End Using close an open SQL Connection
  4. Does this code prevent SQL injection?
  5. TSQL md5 hash different to C# .NET md5
  6. How do I write LINQ’s .Skip(1000).Take(100) in pure SQL?
  7. How can you name the Dataset’s Tables you return in a stored proc?
  8. Generating sql code programmatically
  9. SQL query for display one field only once which having multiple record
  10. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  11. Multi-statement Table Valued Function vs Inline Table Valued Function
  12. How do you return the column names of a table?
  13. Dynamically create columns sql
  14. What’s the best method to pass parameters to SQLCommand?
  15. INT vs Unique-Identifier for ID field in database
  16. Why do you create a View in a database?
  17. SQL query to find Nth highest salary from a salary table
  18. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  19. Sanitize table/column name in Dynamic SQL in .NET? (Prevent SQL injection attacks)
  20. T-SQL: How to use parameters in dynamic SQL?
  21. Get the records of last month in SQL server
  22. Merge overlapping date intervals
  23. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  24. alternatives to REPLACE on a text or ntext datatype
  25. Why is some sql query much slower when used with SqlCommand?
  26. Split words with a capital letter in sql
  27. SQL poor stored procedure execution plan performance – parameter sniffing
  28. scope_identity vs ident_current
  29. Compare dates in T-SQL, ignoring the time part
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment