这个sql语句怎么解决?
int c;select Num ,name,type,c*ammout from jzy1308a12v
其中c是自定义的一个整型变量,怎样才能把C的值传入到这条sql 语句中?
C# SQL --------------------编程问答-------------------- string.format(“select Num ,name,type,{0} from jzy1308a12v“,c*ammout) --------------------编程问答-------------------- 二楼正解,用的就是字符串格式化的解决…… --------------------编程问答-------------------- 用string.Format
string strUpdate = string.Format(@" update empattenceaudit set auditstate=1 where Yearmonth='{0}' and empid={1} and
exists (select 1 from empattenceaudit where Yearmonth='{0}' and companyid={2} and coalesce(auditstate,0)=1 )",
strYearMonth, EmpId, strCompany);
或者字符串直接拼接
string sqlgz = @"select SHEETID from TBLPAYLISTSHEET--------------------编程问答-------------------- string sql="select Num ,name,type,"+"'+c.ToString()+'"+"*ammout from jzy1308a12v";
where YEARMONTH='" + findYearMonth + "' and WHETHERIMPORT=1";
--------------------编程问答--------------------
+1 --------------------编程问答-------------------- +1 --------------------编程问答-------------------- 动态拼sql --------------------编程问答-------------------- 我比较赞同4楼的 --------------------编程问答-------------------- select Num ,name,type,"+c+"*ammout from jzy1308a12v
--------------------编程问答-------------------- select Num ,name,type,"+c+"*ammout from jzy1308a12v --------------------编程问答--------------------
+1 --------------------编程问答-------------------- 北大青鸟的? --------------------编程问答-------------------- 可能是 --------------------编程问答-------------------- declare @C INT
EXEC('select '+@C+'=count(*) from '+@TableName) --------------------编程问答-------------------- 同意4楼做法 --------------------编程问答-------------------- 楼主该结贴了
补充:.NET技术 , C#