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;