1.创建数据库,设置数据库位置
--创建数据库
USE master
go
if exists(select * from sysdatabases where name='EmployeeSys')...go
CREATE DATABASE EmployeeSys
ON
(
NAME = ' EmployeeSys_data', --主数据文件的逻辑名...FILENAME = 'D:\EmployeeSys_data.mdf' , --主数据文件的物理名
SIZE = 10 MB, --主数据文件初始大小
FILEGROWTH = 20...FILENAME = 'D:\EmployeeSys_log.ldf' ,
SIZE = 3MB,
MAXSIZE = 20MB,
FILEGROWTH = 1MB
)
GO
2.选择数据库...into Employee values('李宁',18,'女','2011-10-1',4000,5,1);
insert into Users values('admin','admin');
5.查询表数据