创建表语句

create table T_Person (Id int not null,Name nvarchar(50),Age int null)

插入

insert into T_Person (Id,Name,Age) values (1,'tom',30)

insert into T_Person values(3,'lily',33,GETDATE())

更新

update T_Person set Age=40 where name='tom' or Age>20

更改表

ALTER TABLE T_Employee ADD FSubCompany VARCHAR(20);

删除表中数据

delete from T_Person

DELETE FROM T_Person WHERE Age > 32

清空表中数据

Truncate table T_Person

删除表

drop table  T_Person