select * from ta where 日期列 between '1900-1-1' and '2000-12-31'
select * from tb datetime between '1999-1-1' and '2000-12-31'
select * from tb CONVERT(VARCHAR(10),TIME,120) between '1999-01-01' and '2000-12-31'
select * from tb year(日期) between 1999 and 2000
select * from tb where year(日期列) between 1999 and 2000
select * from 表 where 日期列 between '2009-01-01' and '2010-01-01'
刚才那个解决了 谢谢大家 之后插入一张新表中 而且新表的类型要与旧表中的列匹配 insert into A select * FROM B WHERE (timekey BETWEEN '2001-1-01' AND '2007-1-31') 但是我没有建立A表,如果不定义A表有没有方法直接插入呢?因为表里的元素实在太多了
select * into A FROM B WHERE (timekey BETWEEN '2001-1-01' AND '2007-1-31')
select * insert into A FROM B WHERE timekey BETWEEN '2001-01-01' AND '2007-01-31'
from ta
where 日期列 between '1900-1-1' and '2000-12-31'
之后插入一张新表中 而且新表的类型要与旧表中的列匹配
insert into A
select *
FROM B
WHERE (timekey BETWEEN '2001-1-01' AND '2007-1-31') 但是我没有建立A表,如果不定义A表有没有方法直接插入呢?因为表里的元素实在太多了
FROM B
WHERE (timekey BETWEEN '2001-1-01' AND '2007-1-31')
select *
insert into A
FROM B
WHERE timekey BETWEEN '2001-01-01' AND '2007-01-31'