Question

sql2005出现的错误？ 消息 102，级别 15，状态 1，第 1 行 '30' 附近有语法错误。 (1 行受影响)

//输入一个时间 减去当前时间 剩余多少天，多少小时，多少秒 create proc [dbo].[XShiJian] @Where nvarchar(50) as DECLARE @Days AS int, @Hours AS int, @Minutes AS int, @Seconds AS int,@sql as nvarchar(2000); --主sql语句; SET @Seconds = DATEDIFF( second,getdate(),@Where); SET @Days = @Seconds / (24 * 60 * 60) SET @Seconds = @Seconds - @Days * 24 * 60 * 60 SET @Hours = @Seconds / (60 * 60); SET @Seconds = @Seconds - @Hours * 60 * 60 SET @Minutes = @Seconds / 60; SET @Seconds = @Seconds - @Minutes * 60; BEGIN set @sql=(SELECT (CONVERT(varchar(10), @Days) + '|' + CONVERT(varchar(10), @Hours ) + '|' + CONVERT(varchar(10), @Minutes ) + '|' + CONVERT(varchar(10), @Seconds))) exec SP_EXECUTESQL @sql output END select @sql as 'TotelTime' //将结果输出 给个默认的列名 //执行存储过程 exec XShiJian @Where=' 2011-11-15 '

Answer 1

exec SP_EXECUTESQL @sql output 这一句不要就Ok啦

麻烦采纳，谢谢!