Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
exercise 1 – fines – database import 1.0.1.sql
tesing
viernes_ alumnos
adbms 0
Cine latinoamericano
CTE with recursive
TRY_SQL
№3
28-02 3
Tabela Hospedes BD
Please log in to post a comment.