正文

C# 执行sql语句批量更新

IP云
IP云V管理员/7 阅读
08/26
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

int x = db.Database.ExecuteSqlCommand(string.Format("update T_Pension SET UnitType = '{0}' WHERE PensionId between '{1}' and '{2}'", value, startmaxid, endmaxid));
//update T_Pension SET UnitType = 0,CreateTime= convert(varchar(100),getdate(),120),CreateUserName='' WHERE PensionId between '1' and '30000'
int x = db.Database.ExecuteSqlCommand(string.Format("update T_Pension SET UnitType = {0},CreateTime= convert(varchar(100),getdate(),120),CreateUserName='{1}' WHERE PensionId between '{2}' and '{3}'",
value,UserInfo.UserName,startmaxid, endmaxid));

start.ToString("yyyy-MM-dd HH:mm:ss")