用反射机制来保存对象到数据库
作者:yaya | 时间:2008年11月29日 | 分类 学海无涯 | 标签 .net 反射 对象 数据库 学习 项目 | 3回复
Incorrect syntax near the keyword User
作者:yaya | 时间:2008年7月17日 | 分类 随便写写 | 标签 keyword User 数据库 错误 问题 | 1回复
不知怎么回事,非要去建立个user表,然后就出错了。网上一捞:
摘自:http://blog.csdn.net/sanking/archive/2007/10/31/1860190.aspx
Today I built one table named 'User' in sqlserver2000 and found one problem.
When I type select * from User at SQL Query Analyzer, one message displayed as below:
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'User'.
O…I see "User" is the keyword of sql. So don't build User table into sql. If u must build one table named User.
The query should be select * from "User"
But If in your java codes or other codes, how to do? I think it must be very complex..so…don't build User table in SQLserver2000.
But if u really must be use User table in programs.
The query statement should be "select * from \"User\"" (Java)
In fact all the query statement can be "select * from \""+tableName+"\""
