34,593
社区成员
发帖
与我相关
我的任务
分享
declare @d nvarchar(10),@Dt datetime,@sql nvarchar(4000)
set @d='d'
set @sql=N'select @Dt=DATEADD('+@d+',1,GETDATE())'
exec sp_executesql @sql,N'@Dt datetime output',@Dt output
select @Dt
declare @d varchar(10)
set @d='d'
exec('select DATEADD('+@d+',1,GETDATE())')
declare @d varchar(10)
set @d='d'
DECLARE @S VARCHAR(100)
SET @S= 'SELECT DATEADD('+@d+',1,GETDATE())'
EXEC( @S)
declare @d varchar(10) ,@s nvarchar(4000)
set @d='d'
set @s=' select DATEADD('+@d+',1,GETDATE())'
exec(@s)
-----------------------
2009-07-22 13:31:39.890