keaokeao的专栏

UPDATE [UserAttList]SET AttValue = cast((cast(AttValue   as   int)+100) as varchar)WHERE (UserName = sjx) AND (AttID = A002)

/* public SqlDataReader GetUserNeedsByUserResType(int userResType,int pageIndex) { this.OpenConn(); this.Comm.CommandText = "select top 20 * from Questions C, (sele

表名是数字开头的，在sql中必须得用[ ]把表名括起来 SELECT *FROM 7CaiWHERE UserName = keao AND AttID = A002这样会提示："第 1 行: 7附近有语法错误。" 正确写法：SELECT *FROM [7Cai]WHERE UserName = keao AND AttID = A002