SQL server 增删改查语句

数据操作

新增

insert into test.dbo.users (id,username,password)
values(1,'lisi',123),(2,'lisi',123);

insert into test.dbo.users (id,username,password)	-- 将查询结果插入
select * from test.dbo.users;

删除

delete test.dbo.users where id=1

修改

update test.dbo.users set username='aaa' where id=1;

查询

select distinct * from test.dbo.users;	-- 去重
select top 3 * from test.dbo.users;		-- 前n行

表操作

创建表

create table teacher(
    id int primary key,
    name varchar(10) not null,
    age int
    )

删除表

drop table teacher;

修改表

	alter table teacher		-- 添加字段
	add name varchar(10) not null;
	
	alter table teacher		-- 删除字段
	drop column name;
	
	exec sp_rename 'teacher.name','newname','COLUMN';	-- 修改字段
	
	alter table teacher		-- 修改字段类型
	alter column name varchar(10) not null;