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 |
|
raysefo
Constraint Violating Yak Guru
260 Posts |
 Posted - 2006-07-29 : 10:28:52
|
| Hi,When i m trying to retrieve data from a table named DAY1(USDCHF1998) , i get this error saying " Sql state 42000, sql error code:155 'USDCHF1998' is not a recognized OPTIMIZER LOCK HINT option ".But its OK, when i use the table as DAY1USDCHF1998 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-07-29 : 11:04:37
|
| If you use special characters in the object name use it with square bracesSelect columns from [DAY1(USDCHF1998)]Also it is good not to use special characters.Refer thishttp://vyaskn.tripod.com/object_naming.htmMadhivananFailing to plan is Planning to fail |
 |
|
|
raysefo
Constraint Violating Yak Guru
260 Posts |
Posted - 2006-08-03 : 12:22:38
|
| Hi,is there a way to create table name like this;[a/b]but it should be listed as above in Query Analyzer or enterprise |
|
|
|
raysefo
Constraint Violating Yak Guru
260 Posts |
Posted - 2006-08-03 : 12:24:37
|
| i asked the question above because, borland developer studio do NOT retrieve data from tables in data explorer that have special characters. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-08-04 : 03:29:09
|
| You should really rely on using _ and - instead of () and /, they will just be a hassle. When using them in table/procedure/column/etc-names you *always* have to put [] around them and your bound to forget sometimes. And when using 3rd party tools like you are you can allready see the problems coming...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-04 : 09:11:29
|
| Also, read the link I postedMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL state 42000, SQL error code 155