Monthly Archives: October 2009

Avoid dollar sign in table name

Dollar sign ($) is allowed to be used in temparory table name in SQL Server. E.g. run the following script in SSMS: CREATE TABLE #AA$(c1 int)INSERT #AA$(c1) VALUES (1)SELECT * FROM #AA$DROP TABLE #AA$GO The script works fine. However, if … Continue reading

Posted in SQL server 2005 | 3 Comments