CREATE TABLE blah (narf VARCHAR(4000), poit VARCHAR(4000))
BULK INSERT blah
from "c:\files\blah.txt"
ALTER TABLE blah
ADD ID int IDENTITY(1,1) NOT NULL
Thursday, January 27, 2011
[SQL] BULK INSERT and adding an identity
So I have a file with two columns, and I need to import it into a table with an IDENTITY column. Here's the easy way:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment