declare @sql1 nvarchar(200),@sql2 nvarchar(200) declare @count nvarchar(100); set @sql1 = 'SELECT CONVERT(varchar(100), GETDATE(), 0)' set @sql2 = 'SELECT @count = CONVERT(varchar(100), GETDATE(), 0)' exec sp_executesql @sql2,N'@count nvarchar(50) out',@count out print @sql1 +'：'+ @count
