日期:2014-05-18 浏览次数:20664 次
dateadd(m,-3,getdate())
------解决方案--------------------
哎,能力有限,帮不了你了,坐等大牛!
------解决方案--------------------
declare @mm as varchar(6)
set @mm = convert(varchar(6),dateadd(month,-3,getdate()),112)
declare @tb as varchar(50)
set @tb = 'sexit' + @mm+'1060003'
exec('drop table ' + @tb)
------解决方案--------------------
declare @mm as varchar(6) set @mm = convert(varchar(6),dateadd(month,-3,getdate()),112) declare @tb as varchar(50) set @tb = 'sexit' + @mm+'1060003' exec('drop table ' + @tb)