Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Pranklin
-
Exec vs. Temp Table
Can anybody explain why this does not work: EXEC ('CREATE TABLE #tmpMine (MyData Int)') EXEC ('INSERT INTO #tmpMine (MyData) VALUES (54)') EXEC ('SELECT * FROM #tmpMine') I get the following errors: Server: Msg 208, Level 16, State 1, Line 1 Invalid object name '#tmpMine'. Server: Msg 208...- Pranklin
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
