34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @sql_pa VARCHAR(20)
DECLARE @sql NVARCHAR(100)
DECLARE @x DATETIME
DECLARE @date_pa1 DATETIME , @date_pa2 DATETIME
DECLARE @i INT
SET @date_pa1 = '2020-01-10'
SET @date_pa2 = '2020-01-15'
SET @i = 1;
WHILE ( @i <= 2 )
BEGIN
SET @sql_pa = '@date_pa' + LTRIM(STR(@i))
SET @sql = 'SELECT @x=' + @sql_pa
EXEC sp_executesql @sql , N'@date_pa1 datetime,@date_pa2 datetime,@x datetime OUTPUT' , @date_pa1 , @date_pa2 , @x OUTPUT
PRINT @x
SET @i = @i + 1
END