test.sql

来自「本系统设有管理员」· SQL 代码 · 共 20 行

SQL

20 行


CREATE TABLE [dbo].[Teacher] (
    [Teacherno] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL primary key ,
    [TeaName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [TeaPwd] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [TeaSex] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
    [TeaTelephone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
    [TeaEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [TeaCanAnnounce] [int] NOT NULL ,
    [TeaIntro] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
    [PersonalPage] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
    [DepartmentNo] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [TitleNo] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
    [Inline] [int] NULL
) ON [PRIMARY]
insert into teacher values('1','admin','0000','','','',1,'','','','','')
insert into teacher values('2','刘海','1234','男','13154287845','liuhai@21cn.com',2,'计算机学院教工篮球队绝对核心','','101','','')
GO

⌨️ 快捷键说明

复制代码Ctrl + C

搜索代码Ctrl + F

全屏模式F11

增大字号Ctrl + =

减小字号Ctrl + -

显示快捷键?

test.sql

test.sql - 源码说明

⌨️ 快捷键说明