求助：各位进来看看

建表時,自動編號
-------------------------
CREATE TABLE [TEST] (
[Ids] [numeric](38, 0) IDENTITY (1, 1) NOT NULL ,
[FEILD1] [char] (10)  NOT NULL ,
[FEILD2] [char] (10)  NULL ,
CONSTRAINT [PK_TEST] PRIMARY KEY  CLUSTERED 
(
[FEILD1]
)  ON [PRIMARY] 
) ON [PRIMARY]--------------------------------------------------------
SELECT  top 10  IDS =Identity(int,1,1) ,*  into #tmp from sysobjects  
 select * from #tmp 
IDS         name                                                                                                                             id          xtype uid    info   status      base_schema_ver replinfo    parent_obj  crdate                                                 ftcatid schema_ver  stats_schema_ver type userstat sysstat indexdel refdate                                                version     deltrig     instrig     updtrig     seltrig     category    cache  
----------- -------------------------------------------------------------------------------------------------------------------------------- ----------- ----- ------ ------ ----------- --------------- ----------- ----------- ------------------------------------------------------ ------- ----------- ---------------- ---- -------- ------- -------- ------------------------------------------------------ ----------- ----------- ----------- ----------- ----------- ----------- ------ 
1           sysobjects                                                                                                                       1           S     1      25     -536870909  96              0           0           2000-08-06 01:29:12.717                                0       96          0                S    1        113     0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
2           sysindexes                                                                                                                       2           S     1      29     -536870907  32              0           0           2000-08-06 01:29:12.717                                0       32          0                S    1        8273    0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
3           syscolumns                                                                                                                       3           S     1      32     -536870909  80              0           0           2000-08-06 01:29:12.717                                0       80          0                S    1        113     0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
4           systypes                                                                                                                         4           S     1      20     -536870909  80              0           0           2000-08-06 01:29:12.717                                0       80          0                S    1        113     0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
5           syscomments                                                                                                                      6           S     1      10     -536870911  48              0           0           2000-08-06 01:29:12.717                                0       48          0                S    1        81      0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
6           sysfiles1                                                                                                                        8           S     1      4      -536870912  0               0           0           2000-08-06 01:29:12.717                                0       0           0                S    1        65      0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
7           syspermissions                                                                                                                   9           S     1      11     -536870911  16              0           0           2000-08-06 01:29:12.717                                0       16          0                S    1        81      0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
8           sysusers                                                                                                                         10          S     1      20     -536870909  96              0           0           2000-08-06 01:29:12.717                                0       96          0                S    1        113     0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
9           sysproperties                                                                                                                    11          S     1      5      -536870911  32              0           0           2000-08-06 01:29:12.717                                0       32          0                S    1        81      0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0
10          sysdepends                                                                                                                       12          S     1      11     -536870909  64              0           0           2000-08-06 01:29:12.717                                0       64          0                S    1        113     0        2000-08-06 01:29:12.717                                0           0           0           0           0           2           0(影響 10 個資料列)