Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CSantos
Starting Member
7 Posts |
 Posted - 2002-09-27 : 07:04:59
|
| My Problema with Sensitive Case in Colum Names or Table Names just happen with temporary tables.When I do This SQL Statement:"Select Descricao INTO #TempA FROM TblMoeda"And Then I Do "SELECT descricao FROM #TempA" OR "SELECT Descricao FROM #Tempa" I have the error:Server: Msg 207, Level 16, State 3, Line 1Invalid column name 'descricao'.OR Server: Msg 208, Level 16, State 1, Line 1Invalid object name '#Tempa'.But if I do "SELECT Descricao FROM #TempA" the command runs correctly.I've my SQL Server with the IDENTIFIER_CASE configured to SENSITIVE. I've Read that if my Server is with SENSITIVE this would happen for all tables and all columns names, not only for temporary tables.Thanks again for your time. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-27 : 07:19:13
|
| Are you sure it's not set off for your database but on for tempdb (and probably the server)?I assume that's possible along with database specific collations.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
IDENTIFIER_CASE