摘要: DECLARE @strPath NVARCHAR(200)set @strPath = replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')set @strPath = REPLACE(@strPath, ':' , '.')set @strPath = 'E:\Backup\Mis.B...阅读全文

摘要: alter procedure testexceptionasdeclare @date datetime;beginbegin try set @date=cast('200012' as datetime); select @date;end trybegin catch select * from master.dbo.sysmessages where [error] = @@error;...阅读全文