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
REGISTRO_ESTUDIANTES
Merge statement
Mahi
Test
TUAN 7_QLCB
student
Create Date list (variable dates) - SQL Server
"OrderForm.asp?Cart="
Microsoft SQL Server in 10 mn - Lesson 14 Joining Tables samples...
l