SQL Command

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello Everyone!

I have 14 years of SQL experience, but am new to SQLServer. I learned that when entering a SQL command via ISQL/w all tables and columns must be uppercased (in fact it is easier to make the whole thing upper case). Recently I was also told there was a switch or configuration setup allows you text which is mixed or lower case. Is this true? If so, how do I execute it?



-- Anonymous, December 29, 1997


Nancy in order to have mixed cases, you will have to rerun the SQL server setup to change the sort order to "dictionary case insensitive". You can do this by selecting the option in the setup of rebuilding the master database. This will make all other databases currectly residing on your server useless so backups of each database are a necessity. After restoring the master database, you can created each database again and do a restore from file. Hope this helps.

-- Anonymous, January 05, 1998

Moderation questions? read the FAQ