SQL 查询语句脚本代码

/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [ID]
,[CardNo]
,[CardID]
,[RegisterPerson]
,[Status]
,[AddTime]
,[Remark]
FROM [E-ReadingRoom].[dbo].[CardInfo]

SELECT * FROM [E-ReadingRoom].[dbo].[CardInfo]
where (AddTime between '2013-05-17 14:40:23.130' and '2013-05-17 14:40:23.130')
and Status=0 and CardNo='17626'

SELECT * FROM [E-ReadingRoom].[dbo].[CardInfo]--只有时间
where (AddTime between '2013-05-17 14:40:23.130' and '2013-05-17 14:40:23.130')


SELECT * FROM [E-ReadingRoom].[dbo].[CardInfo]--有时间有状态的
where (AddTime between '2013-05-17 14:40:23.130' and '2013-05-17 14:40:23.130')
and Status=0

SELECT * FROM [E-ReadingRoom].[dbo].[CardInfo]--有时间有卡号没有状态的
where (AddTime between '2013-05-17 14:40:23.130' and '2013-05-17 14:40:23.130')
and CardNo='17626'

SELECT * FROM [E-ReadingRoom].[dbo].[CardInfo]--全部都有的
where (AddTime between '2013-05-17 14:40:23.130' and '2013-05-17 14:40:23.130')
and Status=0 and CardNo='17626'