declare @starttime datetime,@Endtime datetime
set @starttime='2010-08-30 07:00:00'
set @Endtime='2010-08-30 08:00:00' SELECT * FROM Times t
WHERE @starttime between BeginTime and EndTime
or @Endtime between BeginTime and EndTime
or BeginTime between @starttime and @Endtime
or EndTime between @starttime and @Endtime
BeginTime EndTime
----------------------- -----------------------
2010-08-30 06:00:00.000 2010-08-30 07:20:00.000
2010-08-30 07:30:00.000 2010-08-30 07:50:00.000
2010-08-30 07:55:00.000 2010-08-30 08:30:00.000
2010-08-30 04:30:00.000 2010-08-30 09:00:00.000
2010-08-30 07:00:00.000 2010-08-30 08:00:00.000(5 行受影响)
set @starttime='2010-08-30 07:00:00'
set @Endtime='2010-08-30 08:00:00' SELECT * FROM Times t
WHERE @starttime between BeginTime and EndTime
or @Endtime between BeginTime and EndTime
or BeginTime between @starttime and @Endtime
or EndTime between @starttime and @Endtime
BeginTime EndTime
----------------------- -----------------------
2010-08-30 06:00:00.000 2010-08-30 07:20:00.000
2010-08-30 07:30:00.000 2010-08-30 07:50:00.000
2010-08-30 07:55:00.000 2010-08-30 08:30:00.000
2010-08-30 04:30:00.000 2010-08-30 09:00:00.000
2010-08-30 07:00:00.000 2010-08-30 08:00:00.000(5 行受影响)
解决方案 »
- 请教我的查询语句有什么问题;
- 谁有 Log Explorer for SQL Server 我给100分 急急急
- 关于MsSQL存储过程语法的疑问
- 在sql 查询分析器中运行update过程中点击停止,数据是否会回滚呢?
- sql_server转换的问题
- SQL 前 n条记录
- 存储过程速度较慢,优化SQL
- 狂郁闷,好不容易做了个东西现在高兴不起来了,大家说说怎么办阿!
- 如何将Access数据库中的表通过ODBC复制到Sybase数据库
- 这个update为什么会出现消息 512,级别 16,状态 1,第 1 行 子查询返回的值不止一个。
- 存储过程中变量放在SQL语句中得不到值
- 求一SQL语句,如何查询两个日期之间的所有日期
set @starttime='2010-08-30 07:00:00'
set @Endtime='2010-08-30 08:00:00' SELECT * FROM Times
where @Endtime>=BeginTime and @starttime<=EndTime/**
BeginTime EndTime
----------------------- -----------------------
2010-08-30 06:00:00.000 2010-08-30 07:20:00.000
2010-08-30 07:30:00.000 2010-08-30 07:50:00.000
2010-08-30 07:55:00.000 2010-08-30 08:30:00.000
2010-08-30 04:30:00.000 2010-08-30 09:00:00.000
2010-08-30 07:00:00.000 2010-08-30 08:00:00.000(5 行受影响)
**/
Create Proc p_Times
As
Declare @starttime DateTime,@Endtime DateTime
Select @starttime='2010-08-30 07:00:00'
Select @Endtime='2010-08-30 08:00:00'
Select * From Times
Where @Endtime>=BeginTime And @starttime<=EndTime
Go--调用存储过程
Exec p_Times
Go