For All Programming solution

Tuesday, January 8, 2013

How to Isert Data From Text File to SQL Server Table

BULK
INSERT TempSOC_Main--Table Name
FROM 'G:\KS_09_01_13_1133\SOCMain.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
Posted by niaz at 10:38 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2024 (1)
    • ►  January (1)
  • ►  2023 (3)
    • ►  September (1)
    • ►  April (1)
    • ►  March (1)
  • ►  2022 (7)
    • ►  August (7)
  • ►  2015 (8)
    • ►  August (1)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (2)
  • ►  2014 (5)
    • ►  June (1)
    • ►  April (3)
    • ►  January (1)
  • ▼  2013 (30)
    • ►  December (3)
    • ►  November (3)
    • ►  August (4)
    • ►  July (1)
    • ►  June (4)
    • ►  May (1)
    • ►  April (5)
    • ►  March (2)
    • ►  February (4)
    • ▼  January (3)
      • How to find the Size of the Screen in C#.net
      • How to delete Duplicate Record From a Table in SQL...
      • How to Isert Data From Text File to SQL Server Table
  • ►  2012 (5)
    • ►  December (2)
    • ►  November (3)

About Me

niaz
View my complete profile
@niazstat. Simple theme. Powered by Blogger.