How to use BULK with Identity

rajan142 · #1 (**permalink**) 01-08-09, 16:18

I have a table call TblA with Id, FN, LN,Tel fields.
ID is Identity FK.

I have to import all the data from csv file. In csv file there is FN, LN and Tel values. So how can i pass ID identity value using BLUK

BULK
INSERT tblA
FROM 'd:\Db_Backup\CSV\impdata.csv'
WITH
(FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

gvee · #2 (**permalink**) 01-08-09, 18:39

You don't pass identity values, you omit this from your destination column list

Code:

CREATE TABLE #identity_test (
   id int identity(1, 1)
 , col1 char(1)
)

INSERT INTO #identity_test (col1)
  VALUES ('A')
INSERT INTO #identity_test (col1)
  VALUES ('B')

SELECT id
     , col1
FROM   #identity_test

GO
DROP TABLE #identity_test

rudba · #3 (**permalink**) 01-08-09, 18:54

I think, he wants to import data from csv file, using BULK??

gvee · #4 (**permalink**) 01-09-09, 03:29

You mean like this: Keeping Identity Values When Bulk Importing Data ?

Internet Services

Web Development

Digital Marketing

Consumer Tech