📄 mssql-database-struts.sql
字号:
/*==============================================================*/
/* Database name: Demo */
/* DBMS name: Microsoft SQL Server 2000 */
/* Created on: 2008-11-12 16:45:26 */
/*==============================================================*/
use master
go
if db_id('demo')>0
drop database Demo
go
create database Demo
go
use Demo
go
/*==============================================================*/
/* Table: userinfo */
/*==============================================================*/
create table userinfo (
userid int identity,
username varchar(20) null,
password varchar(20) null,
birthday datetime null,
address varchar(200) null,
constraint PK_USERINFO primary key (userid)
)
go
insert into userinfo
select '杰克逊','123456','2008-8-8','美国' union
select '小明','654321','2001-1-1','北京' union
select '小徐','456789','1987-8-25','龙庙乡'
go
select * from userinfo
go
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -