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

sqlserver2005插入语句，insert没有用N（代码实例）

程序员文章站 2022-03-09 21:33:51
 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;

上一篇： 实战引流思维分享：打造一套引流推广体系

下一篇： AJAX和JSP混合使用

推荐阅读