水平拆分测试

use master;
drop database mydata;
create database mydata;
use mydata;
create table t_user_1
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_1 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i1 int;
set @i1 = 0;
while @i1 < 23
begin
	insert into t_user_1 (username, passwd, gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_1
    set @i1 = @i1 + 1
end
create table t_user_2
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_2 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i2 int;
set @i2 = 0;
while @i2 < 23
begin
	insert into t_user_2 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_2
	 set @i2 = @i2 + 1
end
create table t_user_3
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_3 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i3 int;
set @i3 = 0;
while @i3 < 23
begin
	insert into t_user_3 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_3
	set @i3 = @i3 + 1
end
create table t_user_4
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_4 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i4 int;
set @i4 = 0;
while @i4 < 23
begin
	insert into t_user_4 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_4
	set @i4 = @i4 + 1
end
create table t_user_5
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_5 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i5 int;
set @i5 = 0;
while @i5 < 23
begin
	insert into t_user_5 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_5
	set @i5 = @i5 + 1
end
create table t_user_6
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_6 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i6 int;
set @i6 = 0;
while @i6 < 23
begin
	insert into t_user_6 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_6
	set @i6 = @i6 + 1
end
create table t_user_7
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_7 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i7 int;
set @i7 = 0;
while @i7 < 23
begin
	insert into t_user_7 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_7
	set @i7 = @i7 + 1
end
create table t_user_8
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_8 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i8 int;
set @i8 = 0;
while @i8 < 23
begin
	insert into t_user_8 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_8
	set @i8 = @i8 + 1
end
create table t_user_9
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_9 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i9 int;
set @i9 = 0;
while @i9 < 23
begin
	insert into t_user_9 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_9
	set @i9 = @i9 + 1
end
create table t_user_10
(
	userguid uniqueidentifier not null default newid(),
	username nvarchar(max) not null default N'',
	passwd nvarchar(max) not null default N'',
	gender nvarchar(max) not null default N'm',
	birthday smalldatetime not null default '1900-1-1',
	homeaddress nvarchar(max) not null default N'',
	idnumber nvarchar(max) not null default N'',
	primary key(userguid)
);
insert into t_user_10 values (newid(), 'aaaa','bbbb','男','1984-1-1' ,'beijing', '111111111111111');
declare @i10 int;
set @i10 = 0;
while @i10 < 23
begin
	insert into t_user_10 (username,passwd,gender,birthday,homeaddress,idnumber) select username,passwd,gender,birthday,homeaddress,idnumber from t_user_10
set @i10 = @i10 + 1
end
go
select * from t_user_1 union
select * from t_user_2 union
select * from t_user_3 union
select * from t_user_4 union
select * from t_user_5 union
select * from t_user_6 union
select * from t_user_7 union
select * from t_user_8 union
select * from t_user_9 union
select * from t_user_10