SQL
keaokeao
这个作者很懒,什么都没留下…
展开
-
sql语句中 int varchar互相转换
UPDATE [UserAttList]SET AttValue = cast((cast(AttValue as int)+100) as varchar)WHERE (UserName = sjx) AND (AttID = A002)原创 2009-07-29 19:02:00 · 2413 阅读 · 0 评论 -
类别查询 父节点标题 sql
/* public SqlDataReader GetUserNeedsByUserResType(int userResType,int pageIndex) { this.OpenConn(); this.Comm.CommandText = "select top 20 * from Questions C, (sele原创 2009-07-29 19:03:00 · 413 阅读 · 0 评论 -
表名是数字开头的,在sql中必须得用[ ]把表名括起来
表名是数字开头的,在sql中必须得用[ ]把表名括起来 SELECT *FROM 7CaiWHERE UserName = keao AND AttID = A002这样会提示:"第 1 行: 7附近有语法错误。" 正确写法:SELECT *FROM [7Cai]WHERE UserName = keao AND AttID = A002原创 2009-06-10 16:45:00 · 2308 阅读 · 0 评论