数据库实验

 

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','[e-mail]');
insert into users(id,names,password,email)values(2,'admin','1233456','[e-mail]');
select *from users;
select names from users;
select distinct names from users order by names;

select name +'+'+password from