SET IDENTITY_INSERT
允许将显式值插入表的标识列中。语法
SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF }
允许将显式值插入表的标识列中。语法
SET IDENTITY_INSERT [ database.[ owner.] ] { table } { ON | OFF }
sqlserver中的表tmpTXT中有一个自增字段id;sqlserver表tmpTXT字段: id indenty,name varchar(30),age int,sex varchar(2),salary float
persons.txt:
张力,25,男,1732.5
马开湾,31,男,1211.4
罗屈关,26,男,678.35
冯彬,23,女,1058.1我需要用asp代码把persons.txt导入到tmpTXT表中,asp的代码该怎么写?