SQL Server
Here some important and useful queries are available
Thursday, January 19, 2012
Insert Data from TextFile to table
BULK INSERT dbo.User_MST
FROM 'c:\TestCSV.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR='\n'
)
SELECT * FROM dbo.User_MST
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment