How to retrieve field names from temporary table (SQL Server 2008)

by 
select * from tempdb.sys.columns where object_id =
object_id('tempdb..#mytemptable');

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Insert an image in a column of a table that already has 5 columns
  3. CROSS JOIN vs INNER JOIN in SQL
  4. How to cast the DateTime to Time
  5. How can I schedule a job to run a SQL query daily?
  6. How to generate a range of numbers between two numbers?
  7. Reset identity seed after deleting records in SQL Server
  8. How to avoid the “divide by zero” error in SQL?
  9. SET versus SELECT when assigning variables?
  10. Multiple INSERT statements vs. single INSERT with multiple VALUES
  11. Generate Dates between date ranges
  12. Real life example, when to use OUTER / CROSS APPLY in SQL
  13. How to print VARCHAR(MAX) using Print Statement?
  14. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  15. How to update Identity Column in SQL Server?
  16. Common Table Expression, why semicolon?
  17. T-SQL split string based on delimiter
  18. Concatenate values based on ID
  19. SQL Server 2008: how do I grant privileges to a username?
  20. How do I find duplicates across multiple columns?
  21. Split values over multiple rows [duplicate]
  22. sql varchar(max) vs varchar(fix)
  23. How do I prevent a database trigger from recursing?
  24. SQL Server: should I use information_schema tables over sys tables?
  25. store arabic in SQL database
  26. Convert Date format into DD/MMM/YYYY format in SQL Server
  27. Converting Select results into Insert script – SQL Server
  28. TSQL – How to use GO inside of a BEGIN .. END block?
  29. SQL take just the numeric values from a varchar
  30. Cumulative Total in MS Sql server [duplicate]

Leave a Comment