create database imr
on --创建数据库文件
(NAME= sunquan,-- --数据库文件的额、逻辑名称
filename='D:\SQLDATA\sunquan.mdf;',--物理名称,路径必须存在
size=10, --数据初始长度为10M
maxsize=50, --最大长度50M
filegrowth=5%) --数据文件每次增长5%
LOG on
(
name=imr_log,
filename='D:\SQLDATA\sunquan_log.ldf',
SIZE=1,
maxsize=5,
FILEGROWTH=1;
)
----单击运行按钮即可创建数据库
drop database imr;--删除数据库
GO
use imr;
Create table users(
id INT PRIMARY KEY,
names varchar(20),
password varchar(20),
email varchar(20)
)
Drop table users;
insert into users(id,names,password,email)values(3,'sunquan','123456','5255324@qq.com');
insert into users(id,names,password,email)values(2,'admin','1233456','23423642@sina.com');
select *from users;
select names from users;
select distinct names from users order by names;
select name +'+'+password from