实例：Sql server和MYsql中update多条数据

概述建站学院文档 mssql server 中 使用动态表名 MY sql server存储过程完整例子 大家直接看代码：MS sql server中使用动态的表名： declare @tableName nvarchar(160) set @tableName = 't_stat_all' declare @sql nvarchar(160) print @tableName set @sql='select count(*) from '+@tableName exec(…

建站学院文档 mssql server 中 使用动态表名 MY sql server存储过程完整例子 大家直接看代码：@H_419_7@

MS sql server中使用动态的表名：
declare @tablename nvarchar(160)
set @tablename = 't_stat_all'
declare @sql nvarchar(160)
print @tablename
set @sql='select count(*) from '+@tablename
exec(@sql)
MysqL语句
update (select sc,tos,sum(click) as click,product,adpID from log_sc_click group by sc,adpID) as a,
t_stat_sc_h_tmp as b
set b.sc_click=a.click
where b.stat_date=str_date and b.hour=str_hour and b.sc=a.sc
and b.tos=a.tos and b.product=a.product and a.adpID=b.adpID;@H_419_7@

MY sql server存储过程完整例子@H_419_7@

set ANSI_NulLS ON
set QUOTED_IDENTIFIER ON
go@H_419_7@

--ALTER procedure [dbo].[ad_stat]
ALTER procedure [dbo].[ad_stat]
@day varchar(20) = null

as
BEGIN try@H_419_7@

if(@day is null)
set @day = convert(varchar(10),dateadd(day,-1,getdate()),121)@H_419_7@

declare @theDay datetime
set @theDay = cast(@day as datetime)@H_419_7@

declare @yesterday varchar(10)
set @yesterday = convert(varchar(10),@theDay,121)@H_419_7@

declare @tablename nvarchar(160)
set @tablename = 'log_adList_'+ left(@yesterday,4)+'_'+substring(@yesterday,6,2)+'_'+substring(@yesterday,9,2)@H_419_7@

declare @sql nvarchar(500)
set @sql=' update t_stat_all '+
' set cl=b.click from '+
' ( '+
' select AllType as ad_ID,posID as posID,count(*) as click '+
' from '+@tablename+
' where datediff(d,VisitTime,'+@theDay+')=0'+
' group by AllType,posID '+
' ) b,t_stat_all a '+
' where datediff(d,a.stat_date,'+@theDay+')=0 and a.posID=b.posID '+
' and a.ad_ID=b.ad_ID ';
exec(@sql)@H_419_7@

END try
begin catch
INSERT INTO actionLogs
([createTime]
,[actionname]
,[type]
,[infor])
VALUES
(getdate(),
'ad_stat',
'error',--error,info
ERROR_MESSAGE())
end catch@H_419_7@ 总结

以上是内存溢出为你收集整理的实例：Sql server和MYsql中update多条数据全部内容，希望文章能够帮你解决实例：Sql server和MYsql中update多条数据所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。