用递归SQL创造测试数据

        当大家做新项目时，如果需要使用数据库里的数据，恰好此时数据库里有没有测试数据，那怎么办呢？

相对于手动一个一个插入，有一个好办法，可以相对而言比较省事地向数据库插入测试数据，那就是递归SQL: P

下面是用到的SQL语句：

with tempTestData(Tlogin_name,Taddress,Tphone,Temail,Treal_name,Tcountry,TcityId,Tpassword,Trole) as
(
	select [login_name],[address],[phone],[email],[real_name],[country],[cityId],[password],[role]
	from [dbo].[per_users] where uid = '12'
	union all
	select Tlogin_name,Taddress,Tphone = 1 + Tphone,Temail,Treal_name,Tcountry,TcityId = 1 + TcityId,Tpassword,Trole
	from tempTestData
	where Tphone < 101
)
insert into [dbo].[per_users] ([login_name],[address],[phone],[email],[real_name],[country],[cityId],[password],[role])
select * from tempTes