欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识！
您现在的位置是： 首页  >  IT编程

sqlserver2005建表语句（insert没有用N）代码实例

程序员文章站 2022-04-27 20:49:19
sqlserver2005建表语句（insert没有用n）代码实例 use [master] go drop database [mydata] go create database [...

sqlserver2005建表语句（insert没有用n）代码实例

use [master]
go
drop database [mydata]
go
create database [mydata]
go
use [mydata]
go
create table [dbo].[t_user]
(
    [id] [int] identity(1,1) not null,
    [username] [nvarchar](max) not null default (n'无'),
    [gender] [nvarchar](max) not null default (n'无'),
    [birthday] [smalldatetime] not null default (n'1900-01-01'),
    [address] [nvarchar](max) not null default (n'无'),
    [idnumber] [nvarchar](max) not null default (n'无'),
    primary key ([id]),
    check ([gender]=n'男' or [gender]=n'女' or [gender]=n'无')
)
insert into t_user ([username]) values ('张三');
insert into t_user ([username], [gender]) values ('李四','男');
insert into t_user ([username], [gender], [birthday]) values ('王五', '女', '1980-1-1');
insert into t_user ([username], [gender], [birthday], [address]) values ('刘六', '男', '1980-1-1', '北京市东城区234号');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
insert into t_user ([username], [gender], [birthday], [address], [idnumber]) values ('七七', '女', '1980-1-1', '北京市东城区234号', '110101198001010010');
select * from t_user;

上一篇： 皇帝让大臣找公鸡下的蛋？看大臣儿子如何破局？

下一篇： 高铁官方APP升级：能连高铁Wi-Fi 免费看视频

推荐阅读