Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Import CSV File Into SQL Server Using Bulk Insert
CREATE TABLE CSVTest (ID INT, FirstName VARCHAR(40), LastName VARCHAR(40), BirthDate SMALLDATETIME) GO BULK INSERT CSVTest FROM 'c:\csvtest.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO --Check the content of the table. SELECT * FROM CSVTest GO --Drop the table to clean up database. DROP TABLE CSVTest GO
run
|
edit
|
history
|
help
0
Exam_1
sql_fb
tableA
group for team members and winners in sql-server
store1
Demo
table variables (temporary tables)
mysql4
Training1
Audit Example