62,046
社区成员
发帖
与我相关
我的任务
分享
--CREATE procedure [dbo].[testlieming]
--as
--begin
declare @dt datetime,@newdt datetime,@newdt2 datetime;
declare @i int;
declare @datediff int--datetime;
set @dt='2011-2-15';
set @datediff=datediff(day,'2011-2-15','2011-2-18');
set @i=0;
WHILE @i < @datediff
begin
set @newdt=dateadd(dd,1,@dt);
SELECT convert(nvarchar(100),@dt ,21) as 时间;
set @dt=@newdt;
set @i=@i+1;
end
--end
/*时间
----------------------------------------------------------------------------------------------------
2011-02-15 00:00:00.000
(1 行受影响)
时间
----------------------------------------------------------------------------------------------------
2011-02-16 00:00:00.000
(1 行受影响)
时间
----------------------------------------------------------------------------------------------------
2011-02-17 00:00:00.000
(1 行受影响)
*/
1.@datediff不应为日期型,而应为了int.
2.这句:SELECT convert(nvarchar(100),@dt ,21) as 时间;
不要用动态语句.