Bulk Insert-Copies a data file into a database table or view in a user-specified format.
Eg-
BULK INSERT test
FROM 'd:\testabc.txt'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR = '\n'
)
Subscribe to:
Post Comments (Atom)
Database maintainance,Customized Software and Product Base Software.
- ajay
- I am Ajay Sinha Expertized in Sql Server and providing the consultancy Services in Database Maintainance , Crystal Report,Developed Application Software in VB,ASP.Net.
No comments:
Post a Comment