Skip to content

Jim Salasek's SQL Server Blog

Sharing what I learn about Sql Server

  • Home
  • About
  • Contact

Recent Posts

  • Msg 4701, Level 16 trying to truncate table through Linked Server February 2, 2021
  • Msg 7399, Level 16, State 1 Linked Server. Access Denied January 5, 2021
  • Another feature I wish SQL Server had. December 3, 2020
  • Msg 8115, Level 16 Arithmetic overflow November 4, 2020
  • SQL Server Columnstore Index Performance Benefits October 6, 2020
August 2020
M T W T F S S
 12
3456789
10111213141516
17181920212223
24252627282930
31  
« Jul   Sep »

Month: August 2020

Quickly load data with Bulk Insert

Did you ever have a csv file that somebody wanted loaded into the database so they could do a quick analyses on it? You could create a SSIS project or use the SSMS import data task, but here is a nice quick and easy way to do it using TSQL.

Continue reading Quickly load data with Bulk Insert
Posted on August 5, 2020June 20, 2020Categories Hints and TipsTags bulk insert, load csvLeave a comment on Quickly load data with Bulk Insert
Create a website or blog at WordPress.com