asp.net论坛从accsess转到sql server后出现错误,应该是SQL语法错了,大侠帮我看看这几个SQL字串
以下几个字串原本是连接ACCSESS时没问题,换成sql server后这样行不行?
sql="select user_id,dateandtime,ishy,usertype from "+usertable+" where user_id="+rep(checkuser)+" and password="+rep(checkpassword)+" and canlogin=1";
sql="update "+usertable+" set dlcs=dlcs+1 where user_id="+rep(checkuser);
sql="update "+usertable+"set fs=fs+"+addfs+",dlcs=dlcs+1,dateandtime='"+DateTime.Now+"' where user_id="+rep(checkuser);
sql="select no from bbslitter where owner3="+rep(checkuser)+" or owner2="+rep(checkuser);
sql="select no from bbslitter where owner1="+rep(checkuser);
sql="select user_id from bbsadmin where user_id="+rep(checkuser);