SQL Server, SSRS and Crystal Reports
Friday, 21 August 2009
Bulk Insert Function - SQL
delete from
dbo.testlistofestabs;
go
bulk insert
testlistofestabs
from
'D:\JOBLOGGING\Establishment import\list of estabs.txt'
with
(
fieldterminator
= '\t',
--tab
rowterminator
= '\n'
--new line
)
go
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment