[MSSQL]添加数据到数据库，ADO.NET入门之前！

建一个表，主键为varchar型，从00000 开始，每一条加1

MSSQL代码以下：

declare @autoid varchar(20),@name varchar(50),@addr varchar(256)
declare @i int,@cnum int,@tempi int
declare @dt datetime
declare @min30 datetime
set @min30 =GETDATE()
set @i=0

select @cnum = COUNT(*) from adonet
if @cnum=0 
    begin
        while @i<200000
        begin
            set @min30 = DATEADD(mi,30,@min30)
            set @name = 'onepc' + RTRIM(@i)
            set @addr = 'cnblogs - ' +  RTRIM(@i)
            set @tempi = LEN(CONVERT(varchar,@i)) -- 10返回2 1000返回 4
            if @tempi=1
                set @autoid = '00000' + RTRIM(@i)
            if @tempi=2
                set @autoid = '0000' + RTRIM(@i)
            if @tempi=3
                set @autoid = '000' + RTRIM(@i)
            if @tempi=4
                set @autoid = '00' + RTRIM(@i)
            if @tempi=5
                set @autoid = '0' + RTRIM(@i)
            if @tempi=6
                set @autoid =  RTRIM(@i)        
            insert into adonet(id,name,addr,datet) values (@autoid,@name,@addr,@min30)
            set @i = @i +1
        end
    end
else
    begin
        print('xxx')  --第一次加，之后加的就没再写代码了      
    end

 运行后的数据库表如下

 

000000    onepc0    cnblogs - 0    2011-10-25 18:25:04.093
000001    onepc1    cnblogs - 1    2011-10-25 18:55:04.093
000002    onepc2    cnblogs - 2    2011-10-25 19:25:04.093
000003    onepc3    cnblogs - 3    2011-10-25 19:55:04.093
000004    onepc4    cnblogs - 4    2011-10-25 20:25:04.093
000005    onepc5    cnblogs - 5    2011-10-25 20:55:04.093
000006    onepc6    cnblogs - 6    2011-10-25 21:25:04.093
000007    onepc7    cnblogs - 7    2011-10-25 21:55:04.093
000008    onepc8    cnblogs - 8    2011-10-25 22:25:04.093
000009    onepc9    cnblogs - 9    2011-10-25 22:55:04.093
000010    onepc10    cnblogs - 10    2011-10-25 23:25:04.093
000011    onepc11    cnblogs - 11    2011-10-25 23:55:04.093
000012    onepc12    cnblogs - 12    2011-10-26 00:25:04.093
000013    onepc13    cnblogs - 13    2011-10-26 00:55:04.093
000014    onepc14    cnblogs - 14    2011-10-26 01:25:04.093
000015    onepc15    cnblogs - 15    2011-10-26 01:55:04.093
000016    onepc16    cnblogs - 16    2011-10-26 02:25:04.093
000017    onepc17    cnblogs - 17    2011-10-26 02:55:04.093
000018    onepc18    cnblogs - 18    2011-10-26 03:25:04.093
000019    onepc19    cnblogs - 19    2011-10-26 03:55:04.093
000020    onepc20    cnblogs - 20    2011-10-26 04:25:04.093
000021    onepc21    cnblogs - 21    2011-10-26 04:55:04.093
000022    onepc22    cnblogs - 22    2011-10-26 05:25:04.093
000023    onepc23    cnblogs - 23    2011-10-26 05:55:04.093
000024    onepc24    cnblogs - 24    2011-10-26 06:25:04.093
000025    onepc25    cnblogs - 25    2011-10-26 06:55:04.093
000026    onepc26    cnblogs - 26    2011-10-26 07:25:04.093
000027    onepc27    cnblogs - 27    2011-10-26 07:55:04.093
000028    onepc28    cnblogs - 28    2011-10-26 08:25:04.093
000029    onepc29    cnblogs - 29    2011-10-26 08:55:04.093
000030    onepc30    cnblogs - 30    2011-10-26 09:25:04.093
000031    onepc31    cnblogs - 31    2011-10-26 09:55:04.093
000032    onepc32    cnblogs - 32    2011-10-26 10:25:04.093
000033    onepc33    cnblogs - 33    2011-10-26 10:55:04.093
000034    onepc34    cnblogs - 34    2011-10-26 11:25:04.093