update table set wendu=wendu +'/' +'30' update table set wendu=wendu +'/' +'26'
create proc pr_name(@wendu int) as begin if not exists(select 1 from tb where convert(varchar(10),[date],120)=convert(varchar(10),getdate(),120)) begin insert into tb select convert(varchar(10),getdate(),120),rtrim(@wendu) end else begin update tb set wendu='/'+rtrim(@wendu) where convert(varchar(10),[date],120)=convert(varchar(10),getdate(),120) end end
--调用存储过程插入值 exec pr_name 20
string strSql = "update scd_table set scdTwen='"+model.scdTwen+"' +'/'+'"+model.scdFxi+"'"; 我要一次传入三个字段,一样的格式,要怎么写额
update scd_tabl set scdTwen='39'+'/'+scdFxi='39'+'/'+scdMbo='39'+'/' where id=1 我这样好像不行
看不懂你在写啥 update scd_tabl set scdTwen=scdTwen+'/'+'39',scdFxi=scdFxi+'/'+'39',scdMbo=scdMbo+'/'+'39' where id=1猜测
楼上的代码 可以,但是我的是MYSQL,运行时报错了
--也猜测一下 update scd_tabl set scdTwen=scdTwen+'/'+scdFxi+'/'scdMbo where id=1
update table set wendu=wendu +'/' +'30'
update table set wendu=wendu +'/' +'26'
as
begin
if not exists(select 1 from tb
where convert(varchar(10),[date],120)=convert(varchar(10),getdate(),120))
begin
insert into tb select convert(varchar(10),getdate(),120),rtrim(@wendu)
end
else
begin
update tb set wendu='/'+rtrim(@wendu)
where convert(varchar(10),[date],120)=convert(varchar(10),getdate(),120)
end
end
--调用存储过程插入值
exec pr_name 20
我要一次传入三个字段,一样的格式,要怎么写额
我这样好像不行
update scd_tabl set scdTwen=scdTwen+'/'+'39',scdFxi=scdFxi+'/'+'39',scdMbo=scdMbo+'/'+'39' where id=1猜测
可以,但是我的是MYSQL,运行时报错了
update scd_tabl set scdTwen=scdTwen+'/'+scdFxi+'/'scdMbo where id=1