Importing a CSV into SQL Server Shouldn't Be This Hard
A frustrating time importing CSV files leads Steve to test the different options.
2021-07-14
9,197 reads
CSV
Get a CSV list of columns in a table
Short little script to get the columns in a table in order into a CSV format.
Can be useful for select or insert statements.
2016-08-30 (first published: 2015-03-23)
3,328 reads
Blogs
Daily Coping 4 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using...
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
Forums
Drop database on Secondary Node from Primary for automatic restore job
hi all We've ventured into the world of AAG's as we have now moved...
Which table design is better ?
Hi, I have a scenario where a worker can do multiple training courses each...
Combine tables with SQL in power bi
Hello everyone, i hope everyone is fantastic!! I've done some SQL queries in power...
Ask SSC