向用户表中批量添加用户

select * from dbo.qp_username

 

/*向用户表中批量添加用户,密码为123456*/
BEGIN TRANSACTION
DECLARE @Sum INT
SET @Sum=101
while(@Sum<201)
BEGIN
INSERT INTO [HDA6].[dbo].[qp_username]
           ([Username]
           ,[Password]
           ,[Realname]
           ,[worknum]
           ,[Unit]
           ,[UnitId]
           ,[Respon]
           ,[ResponId]
           ,[Post]
           ,[PostId]
           ,[StardType]
           ,[Email]
           ,[Iflogin]
           ,[Sex]
           ,[ShouJi]
           ,[Remark]
           ,[settime]
           ,[QxString]
           ,[KeyQx]
           ,[ResponQx])
     VALUES
           ('test'+CONVERT (VARCHAR (5),@Sum)
           ,'E10ADC3949BA59ABBE56E057F20F883E'
           ,'test'+CONVERT (VARCHAR (5),@Sum)
           ,+@Sum
           ,'总公司'
           ,'82'
           ,'test'
           ,'34'
           ,'职员'
           ,'25'
           ,'是'
           ,'test'+CONVERT (VARCHAR (5),@Sum)+'@cssp.com'
           ,'是'
           ,'男'
           ,'123456'
           ,NULL
           ,'2012-10-29 14:30:21.000'
           ,'aaaaa'
           ,'允许管理子部门数据'
           ,'|1111b1|1111c1|1111y01|1111y02|1111y03|cccc1a1|cccc1a|cccc1ba|1111d1|1111d2|1111e6|1111f|1111g1|1111g2|11g11g31|1111h01|1111h3|1111i2|1111i3|1111k|1111l4|1111l5|1111l6|ppppp01|bbbb2a|bbbb2b|bbbb3|bbbb4a|bbbb4b|bbbb4c|bbbb4d|bbbb4e|bbbb4f|cccc2c1|cccc2c2|cccc2c3|cccc2c4|cccc2c5|cccc3a|cccc4a|cccc4f|cccc4d|cccc4j|cccc5a|cccc5b|cccc5c|cccc5f|cccc6b|dddd1|dddd2|dddd3|dddd4a|dddd4b|dddd5a|dddd5b|dddd6a|dddd7a|dddd7b|dddd8|dddd9|eeee2c3|eeee2d3|eeee2a3|eeee2b3|eeee9a|eeee6a|eeee6b|eeee8b|ffff1d|kkkkka01|kkkkkb01|kkkkkc01|kkkkkd01|kkkkke01|kkkkkf01|kkkkkg01|ffff6a|ffff6c|ffff6d|ffff6e|hhhh2|hhhh3|hhhh4a|hhhh4b|hhhh5a|hhhh5b|hhhh6|gggg2|gggg3|gggg4|gggg5|gggg6|iiiia1a|iiiia1b|iiiia1c|iiii9|pppp101|pppp201|ddddo01|mmmm01|1111b2b|1111c2b|cccc1cb|1111e4b|1111e5b|1111e2b|1111e3b|1111i1b|1111i4b|bbbb1ab|cccc2ab|cccc2b1b|cccc2b2b|cccc2b3b|cccc2b4b|cccc2b5b|cccc3bb|cccc3cb|cccc4cb|cccc5db|cccc5eb|cccc5gb|cccc6ab|cccc6cb|cccc6db|eeee1ab|eeee1bb|eeee6cb|eeee6db|eeee6eb|eeee8ab|eeee4b|eeee5b|ffff1a1b|ffff1a2b|ffff1bb|ffff1cb|ffff2ab|ffff2bb|ffff2cb|ffff2db|ffff3cb|ffff4ab|ffff4b1b|ffff4b2b|ffff5cb|kkkkka02|kkkkkc02|kkkkkf02|kkkkkg02|ffff7ab|ffff7bb|ffff7cb|hhhh1b|hhhh7b|iiii3b|iiii4b|iiii5b|iiii6b|iiii7b|1111b2c|1111c2c|cccc1cc|1111e4c|1111e5c|1111e2c|1111e3c|1111i1c|bbbb1ac|cccc2ac|cccc2b1c|cccc2b2c|cccc2b3c|cccc2b4c|cccc2b5c|cccc3bc|cccc3cc|cccc4cc|cccc4ec|cccc5dc|cccc5ec|cccc5gc|cccc6ac|cccc6cc|cccc6dc|eeee1ac|eeee1bc|eeee6cc|eeee6dc|eeee6ec|eeee8ac|eeee4c|eeee5c|ffff1a1c|ffff1a2c|ffff1bc|ffff1cc|ffff2ac|ffff2bc|ffff2cc|ffff2dc|ffff3cc|ffff4ac|ffff4b1c|ffff4b2c|ffff5cc|kkkkka03|kkkkkd03|kkkkke03|kkkkkf03|ffff7ac|ffff7bc|ffff7cc|hhhh1c|hhhh7c|iiii3c|iiii4c|iiii5c|iiii6c|iiii7c|1111b2d|1111c2d|cccc1cd|1111e4d|1111e5d|1111e2d|1111e3d|1111i1d|1111i4d|bbbb1ad|cccc2ad|cccc2b1d|cccc2b2d|cccc2b3d|cccc2b4d|cccc2b5d|cccc3bd|cccc3cd|cccc4cd|cccc4ed|cccc5dd|cccc5ed|cccc5gd|cccc6ad|cccc6cd|cccc6dd|eeee1ad|eeee1bd|eeee6cd|eeee6dd|eeee6ed|eeee8ad|eeee4d|eeee5d|ffff1a1d|ffff1a2d|ffff1bd|ffff1cd|ffff2ad|ffff2bd|ffff2cd|ffff2dd|ffff3cd|ffff4ad|ffff4b1d|ffff4b2d|ffff5cd|kkkkka04|kkkkkd04|kkkkke04|kkkkkg04|ffff7ad|ffff7bd|ffff7cd|hhhh1d|hhhh7d|iiii3d|iiii4d|iiii5d|iiii6d|iiii7d|1111b2e|1111c2e|cccc1ce|1111e4e|1111e5e|1111e2e|1111e3e|1111i1e|1111i4e|bbbb1ae|bbbb1be|cccc2ae|cccc2b1e|cccc2b2e|cccc2b3e|cccc2b4e|cccc2b5e|cccc3be|cccc3ce|cccc4ce|cccc5de|cccc5ee|cccc5ge|cccc6ae|cccc6ce|cccc6de|eeee1ae|eeee1be|0eeee6ce|eeee6de|eeee6ee|eeee8ae|eeee4e|eeee5e|ffff1a1e|ffff1a2e|ffff1be|ffff1ce|ffff2ae|ffff2be|ffff2ce|ffff2de|ffff3ce|ffff4ae|ffff4b1e|ffff4b2e|ffff5ce|kkkkka05|kkkkkd05|kkkkke05|kkkkkf05|kkkkkg05|ffff7ae|ffff7be|ffff7ce|hhhh1e|hhhh7e|iiii3e|iiii4e|iiii5e|iiii6e|iiii7e|iiii8e|iiiia1de|1111e4f|1111e5f|1111e2f|1111e3f|1111i1f|cccc2af|cccc2b1f|cccc2b2f|cccc2b3f|cccc2b4f|cccc2b5f|cccc3cf|cccc4cf|cccc5df|cccc5ef|cccc6af|eeee1af|eeee1bf|eeee6cf|eeee6df|eeee6ef|eeee4f|eeee5f|ffff1a1f|ffff1a2f|ffff1bf|ffff1cf|ffff2af|ffff2bf|ffff2cf|ffff2df|ffff3cf|ffff4af|ffff4b1f|ffff4b2f|ffff5cf|kkkkka06|kkkkkb06|iiii4f|iiii8f|iiiia1df|kkkkka07|kkkkkd07|kkkkke07|kkkkkf07|iiii4h|iiii5h|1111b2i|1111c2i|cccc1ci|1111e4i|1111e5i|1111e2i|1111e3i|1111i1i|1111i4i|bbbb1ai|bbbb1bi|cccc2ai|cccc2b1i|cccc2b2i|cccc2b3i|cccc2b4i|cccc2b5i|cccc3bi|cccc3ci|cccc4ci|cccc4ei|cccc5di|cccc5ei|cccc5gi|cccc6ai|cccc6ci|cccc6di|eeee1ai|eeee1bi|eeee6ci|eeee6di|eeee6ei|eeee4i|eeee5i|ffff1a1i|ffff1a2i|ffff1bi|ffff1ci|ffff2ai|ffff2bi|ffff2ci|ffff2di|ffff3ci|ffff4ai|ffff4b1i|ffff4b2i|ffff5ci|kkkkka09|kkkkkb09|kkkkkd09|kkkkke09|ffff7ai|ffff7bi|hhhh1i|hhhh7i|iiii3i|iiii4i|iiii5i|iiii7i|iiii8i|iiiia1di|1111y11|1111y21|1111y31|cc1ccc11|cc1ccc1|cc2ccc1|11d11d11|11d11d21|11a11e6a|11e11e4e3|11e11e5e3|11e11e2e3|11e11e3e3|11f11f1|11g11g1|11g11g2|11g11g32|11111h11|11h111h31|11i11i21|11i11i31|11k11k1|11411l41|11511l51|11611l61|bb1bba1|bb2bba2|bbabb4a1|bbabb4b1|cc1cc2b1|cc2cc2b1|cc3cc2b1|cc4cc2b1|cc5cc2b1|ccfcc4f1|cc4cc4e1|cc5cc5d1|cc6cc6a1|dd1dd1a|dd2dd2a|dd3dd3a|ddadd7a1|dd7dd7b1|dd8dd8a|dddd91|ff1pffa1|ff1pffa2|ff1kffb3|ff1kffb4|ff1affj1|ff1affj2|ff1affj3|ff1affj4|ff1eff3|ff1zffj1|ff1bzff1|ff1bzff2|ff1eff5|kkkkka10|kkkkkb10|kkkkkd10|ff1abff1|ff2abff1|ff6dff6d1|ff6eff6e1|hh1hh1|ii1aii8|11b11b11|11b11b22|11c11c11|11c11c2c2|cc1ccc3|11i11i13|11i11i43|bb3bb2a|bb3bb2b|bb3bb3a|bbabb4c3|bbabb4d3|bbabb4e3|bbabb4f3|cc1cca3|cc1cc2c1|cc2cc2c1|cc3cc2c1|cc4cc2c1|cc5cc2c1|cc1cc3a2|cc3ccba1|cc4ccca1|cc4cc4a1|cc4cc4c2|cc4cc4d1|ccjcc4j1|cc5cc5a1|cc5cc5b1|cc5cc5c1|cc5cc5e3|cc5cc5f3|cc5cc5g3|cc6cc6b1|cc6cc6c1|cc6cc6d1|dd4dd4a1|dd4dd4b1|dd5dd5a1|dd5dd5b1|dd6dd6a1|eeaee1a3|eebee1b3|eecee2c1|eedee2d1|eeaee2a1|eebee2b1|eeaee9a1|eeaee6a1|eebee6b1|eeaee6c1|eeaee6d1|eeaee6e1|eeaee8a3|eebee8b3|ee4ee4a3|ee5ee5a3|ff3kffb5|ff3ff7a1|ff3ff7b1|ff3ff7c1|hh1hh1a|hh7hh7a|hh2hh2a|hh3hh3a|hhahh4a3|hhbhh4b3|hhahh5a3|hhbhh5b3|hh6hh6a|gg3gg2|gg3gg3|gg5gg5|gg5gg5|iiaiia1a1|iiaiia1a2|iiaiia1a3|ii3ii3|ii3ii4|ii3ii5|ii3ii6|ii3ii7|ii9ii9a|iiiia1dk'
)

SET @Sum=@Sum+1
END

commit