hehe ,不明白楼主说的意思。
解决方案 »
- 求一个关于时间差的存储过程
- 求一存储过程
- 存储过程的疑问,谢谢
- SQL语句编译的时候没有问题,执行时出错,请问怎么回事?
- 如何删除其他用户的数据库
- 求一个SQL Server 2005字符串解决方法
- 執行循環, 復制遠程數據庫數據到本地時,怎樣動態改變set identity_insert tableName on中的表名?
- 在存储过程里面怎样调用自定义的Dll函数(Delphi编写的Dll)
- 请KittyWang(Kitty)和stingzy(小道)进来拿分。
- 我的SQL Server怎么登录不了??????????????
- 更新数据表结构(如增加新字段),和他相关的视图出现错列现象
- 一个查询问题???
drop table tb
gocreate table tb(dt datetime, val int)
insert into tb(dt,val) values('2007-01-01 00:00:00' , 1)
insert into tb(dt,val) values('2007-01-01 00:05:00' , 2)
insert into tb(dt,val) values('2007-01-01 00:10:00' , 3)
insert into tb(dt,val) values('2007-01-01 00:15:00' , 4)
insert into tb(dt,val) values('2007-01-01 00:18:00' , 5)
insert into tb(dt,val) values('2007-01-01 00:20:00' , 6)
insert into tb(dt,val) values('2007-01-01 00:21:00' , 7)
insert into tb(dt,val) values('2007-01-01 00:22:00' , 8)
insert into tb(dt,val) values('2007-01-01 00:30:00' , 9)
insert into tb(dt,val) values('2007-01-01 00:05:00' , 10)
insert into tb(dt,val) values('2007-01-01 00:40:00' , 11)
insert into tb(dt,val) values('2007-01-01 00:50:00' , 12)
insert into tb(dt,val) values('2007-01-01 00:51:00' , 13)
insert into tb(dt,val) values('2007-01-01 00:52:00' , 14)
insert into tb(dt,val) values('2007-01-01 00:55:00' , 15)
godeclare @dt1 as datetime
declare @dt2 as datetime
set @dt1 = '2007-01-01 00:00:00'
set @dt2 = '2007-01-01 01:00:00'
declare @间隔 as int --间隔时间,
set @间隔 = 5 --5分钟
select * from tb where dt >= @dt1 and dt <= @dt2 and datediff(minute , dt , @dt1) % @间隔 = 0drop table tb/*
dt val
------------------------------------------------------ -----------
2007-01-01 00:00:00.000 1
2007-01-01 00:05:00.000 2
2007-01-01 00:10:00.000 3
2007-01-01 00:15:00.000 4
2007-01-01 00:20:00.000 6
2007-01-01 00:30:00.000 9
2007-01-01 00:05:00.000 10
2007-01-01 00:40:00.000 11
2007-01-01 00:50:00.000 12
2007-01-01 00:55:00.000 15(所影响的行数为 10 行)*/