Avoid any Bitwise Keywords

来源: DBDB 于 2004-02-18 10:49:48 [] [旧帖] [给我悄悄话] 阅读数 : (661 bytes)
回答: try [T&WContracts] 由 f64 于 2004-02-18 08:59:38

Peter,
I tried as this:
create table [S&M](num int)
insert into [S&M](num) values(1)
insert into [S&M](num) values(2)
insert into [S&M](num) values(3)
select * from [S&M]
num
-----------
1
2
3

It works.

Did the developer PC applied SQL2K-SP3a? Try it.

"&" has special meaning is Microsoft products, try to avoid it for any object naming. I think that table was from other database upsizing, ex. Access. A quick soluthion to rename the table, or any such tables, to
[T_WContracts],that name is still readable as similar meaning, but less trouble in coding.
Hopefully this ways work for you.

请您先登陆，再发跟帖！