【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供005.sql参考,解决您在005.sql学习中工作中的难题,参考学习。
use db_Sql
GO
if exists(select * from INFORMATION_SCHEMA.TABLES
where table_name = 'tb_employee01')
drop table tb_employee01
GO
-- 创建雇员信息表“tb_employee01”
create table tb_employee01
(
员工 varchar(20),
员工性别 varchar(30),
员工年龄 int,
出生日期 datetime,
备注 text
)
GO
--向雇员信息表中插入几条信息
insert into tb_employee01 values('石乐','女','22','1986-03-12','无')
insert into tb_employee01 values('王强','男','25','1983-10-10','无')
insert into tb_employee01 values('通通','女','24','1984-04-24','无')
insert into tb_employee01 values('大熊','男','23','1985-01-12','无')
insert into tb_employee01 values('紫心','女','23','1985-02-16','无')
GO
select *
from tb_employee01
where 出生日期>'1985-01-01'