For some reason I can never remember to properly retrieve connection specific temporary table’s structure, i.e. #tempCustomers. Due to the fact that the table resides in tempdb, this is the format required:
use tempdbHighlight these two lines in Management studio and press F5!
exec sp_help #tempCustomers
No comments:
Post a Comment