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
February 2021
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
« Jan    

Tag: load csv

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