想查询从一个时间到另一个时间里的记录信息的sql语句，求大牛指导下！

Question

 如同标题：想查询从一个时间到另一个时间里的记录信息
 的sql怎么写呀？
  SELECT     dbo.GuestRecord.GuestID, dbo.GuestRecord.GuestName, dbo.GuestRecord.IdentityID,  dbo.GuestRecord.ResideDate, dbo.GuestRecord.Deposit, 
                      dbo.ResideState.ResideName, dbo.GuestRecord.LeaveDate, dbo.GuestRecord.TotalMoney, dbo.GuestRecord.RoomID, dbo.RoomType.TypeName, 
                      dbo.RoomState.RoomStateName
FROM         dbo.GuestRecord INNER JOIN
                      dbo.ResideState ON dbo.GuestRecord.ResideID = dbo.ResideState.ResideId CROSS JOIN
                      dbo.RoomState CROSS JOIN 
                      dbo.RoomType
where 

Answer 1

between 起始时间 and 结束时间

Answer 2

where datetime(时间字段) between '2012-9-1' and '2012-9-16' 

Answer 3

 SELECT dbo.GuestRecord.GuestID, dbo.GuestRecord.GuestName, dbo.GuestRecord.IdentityID, dbo.GuestRecord.ResideDate, dbo.GuestRecord.Deposit,  
  dbo.ResideState.ResideName, dbo.GuestRecord.LeaveDate, dbo.GuestRecord.TotalMoney, dbo.GuestRecord.RoomID, dbo.RoomType.TypeName,  
  dbo.RoomState.RoomStateName
FROM dbo.GuestRecord INNER JOIN
  dbo.ResideState ON dbo.GuestRecord.ResideID = dbo.ResideState.ResideId CROSS JOIN
  dbo.RoomState CROSS JOIN  
  dbo.RoomType
where dbo.GuestRecord.ResideDate  between '2012-09-01' and '2012-09-16' 

Answer 4

 SELECT dbo.GuestRecord.GuestID, dbo.GuestRecord.GuestName, dbo.GuestRecord.IdentityID, dbo.GuestRecord.ResideDate, dbo.GuestRecord.Deposit,  
  dbo.ResideState.ResideName, dbo.GuestRecord.LeaveDate, dbo.GuestRecord.TotalMoney, dbo.GuestRecord.RoomID, dbo.RoomType.TypeName,  
  dbo.RoomState.RoomStateName
FROM dbo.GuestRecord INNER JOIN
  dbo.ResideState ON dbo.GuestRecord.ResideID = dbo.ResideState.ResideId CROSS JOIN
  dbo.RoomState CROSS JOIN  
  dbo.RoomType
where
--写法1
 dbo.GuestRecord.ResideDate  between '2012-09-01' and '2012-09-16' 
--写法2
 dbo.GuestRecord.ResideDate>='2012-09-01' and dbo.GuestRecord.ResideDate<'2012-09-16'

Answer 5

SELECT dbo.GuestRecord.GuestID, dbo.GuestRecord.GuestName, dbo.GuestRecord.IdentityID, dbo.GuestRecord.ResideDate, dbo.GuestRecord.Deposit,   
  dbo.ResideState.ResideName, dbo.GuestRecord.LeaveDate, dbo.GuestRecord.TotalMoney, dbo.GuestRecord.RoomID, dbo.RoomType.TypeName,   
  dbo.RoomState.RoomStateName
FROM dbo.GuestRecord INNER JOIN
  dbo.ResideState ON dbo.GuestRecord.ResideID = dbo.ResideState.ResideId CROSS JOIN
  dbo.RoomState CROSS JOIN   
  dbo.RoomType
where
--写法1
 dbo.GuestRecord.ResideDate between '2012-09-01' and '2012-09-16'  
--写法2
 dbo.GuestRecord.ResideDate>='2012-09-01' and dbo.GuestRecord.ResideDate<'2012-09-16'

Answer 6

Between StartTime（开始时间） And EndTime(结束时间)