日期:2014-05-17 浏览次数:20559 次
DECLARE @q datetime,@a datetime
DECLARE @p datetime,@l datetime
SET @q='2011-06-21'SET @a='2012-06-21'
SET @p='2011-06-23'SET @l='2012-06-23'
declare @sql string(800)
@sql =' Set '+@q+'=''2011-06-21'' ,Set '+@q+'=''2011-06-21'' , Set'+@a+'=''2012-06-21'' ,Set '+@p+'=''2011-06-23'' ,Set '+@l+'=''2012-06-23''
exec(@sql)