急 from 关键字附近有语法错误
来源:学生作业帮 编辑:神马作文网作业帮 分类:综合作业 时间:2024/09/27 07:28:29
急 from 关键字附近有语法错误
string sql = "select top " + Parameter[5].ToString() + " from " + TableName + " where ColumnsId=" + Parameter[1].ToString() + "and ZT=1";
string sql2 = "";
if (Parameter[2].ToString() == "0")
{
sql2 = "and IsTop=0";
}
else
{
sql2 = "and IsTop=1";
}
sql += sql2;
string sql3 = "";
if (Parameter[3].ToString() == "0")
{
sql3 = "and IsJd=0";
}
else
{
sql3 = "and IsJd=1";
}
sql += sql3;
string sql4 = "";
if (Parameter[4].ToString() == "0")
{
sql4 = "and IsTj=0";
}
else
{
sql4 = "and IsTj=1";
}
sql += sql4;
string sql5 = "order by id desc";
sql += sql5;
db.ExecuteSQL(sql);
db.CloseConn();
string sql = "select top " + Parameter[5].ToString() + " from " + TableName + " where ColumnsId=" + Parameter[1].ToString() + "and ZT=1";
string sql2 = "";
if (Parameter[2].ToString() == "0")
{
sql2 = "and IsTop=0";
}
else
{
sql2 = "and IsTop=1";
}
sql += sql2;
string sql3 = "";
if (Parameter[3].ToString() == "0")
{
sql3 = "and IsJd=0";
}
else
{
sql3 = "and IsJd=1";
}
sql += sql3;
string sql4 = "";
if (Parameter[4].ToString() == "0")
{
sql4 = "and IsTj=0";
}
else
{
sql4 = "and IsTj=1";
}
sql += sql4;
string sql5 = "order by id desc";
sql += sql5;
db.ExecuteSQL(sql);
db.CloseConn();
string sql = "select top ' " +convert.Toint32 (Parameter[5]) + "' from TableName where ZT=1 and ColumnsId='"+ Parameter[1].ToString() + " '";
对了就给分哈!
对了就给分哈!
SQL2005 报错 在关键字'group' 附近有语法错误
有温度的梦想 1急!关键字 埃文 珍道儿
Did paper be made from wood 有语法错误吗?
这句英语有语法错误吗?Rice from UK,needed?
what nationality are you from这句话有语法错误么?
帮我检查下句子是否有语法错误?急
急 英文询问信 帮忙检查一下有没有语法错误
请问这句英文是什么意思,有没有语法错误?(急)
英文歌auld lang syne 是不是有语法错误?好急,
[急求鉴定]这句英文有语法错误么
【急】帮忙看看这句英文有没有语法错误.
sqlserver中if else的用法,我写的这个存储过程 提示else附近有语法错误