Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BULK INSERT questions
Message
De
14/01/2009 17:52:06
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
BULK INSERT questions
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01373782
Message ID:
01373782
Vues:
67
I am using bulk insert to insert records from a flat pipe delimited file to a table. Here is the script I am using:
BULK INSERT
	MyTable
FROM
	'c:\MyFile.txt'
WITH
(
	FIELDTERMINATOR = '|'
	, ROWTERMINATOR = '|\n'
	, FIRSTROW = 2
)
I have two questions:
First, is there a way to avoid the rows being index based? Is there way to use the column header to determine what field the element belongs in, instead of just skipping the row like I am in the example?

Second (and this might be related to the first question), is there a way to include an auto-incrementing PK field?
Very fitting: http://xkcd.com/386/
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform