I'm looking to import roughly 10,000 rows (this is from a CVS file) into an existing SQL Server 2012 table.
I only have 1 column to import but there's another table in my column titled "TypeID". For this column, I need to set a static value like this:
INSERT INTO TABLE ([Name], [TypeId])
Values (@Name (CSV value), "99E05902-1F68-4B1A-BC66-A143BFF19E37")
Is this possible? Can anyone help me out? Thank you!
October 11, 2013 3:12 PM