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

美 王力宏,板栗切口机,蓝剑刀锋

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;

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复