技术积累、分享成果

insert into  T_FYMM (费用名目,所属部门) select 费用名目,所属部门 from  T_FYMM1

原语句：update dbo.TBL_Projectset dbo.TBL_Project.pro_Name=@pro_Namewhere dbo.TBL_Project.pro_ID=dbo.TBL_FinanciaLInfo.pro_ID      and dbo.TBL_FinanciaLInfo.cer_ID=@cer_ID提示错误：消息 4104，级别 16，状态

declare @begin datetime,@end datetimeset @begin =getdate()SELECT * from ... --SQL 语名set @end=getdate()PRINT DATEDIFF(millisecond, @begin, @end)/1000.0 --单位：s

安装SqlServer2008R2遇到系统提示：SQL Server setup media does not support the language of the OS or does not have ENU localized files.Use the matching language-specific SQL Server media or change the OS loc

SELECT code ,datatime, Year(datatime) AS Y,Month(datatime) AS M,Day(datatime) AS d,HOUR(datatime) AS h, FLOOR(MINUTE(datatime) / 5) AS v , avg(voltage2) from wlwdata.t_h_airelectryvalue