Excel LET Formula for creating small values tables from a table or range
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
433 reads
Andy Robertson
Excel Formula to create SQL Script for a Values Table
Here is an Excel formula that generates a SQL script from an Excel table
2021-07-30 (first published: 2021-07-26)
1,398 reads
Check your default constraints
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
2018-09-17
3,489 reads
When sp_HelpText is not so helpful!
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,403 reads
2017-05-09 (first published: 2017-05-03)
1,655 reads
Blogs
Techorama 2022 Slides
By Steve Jones
I had a great time at Techorama. I’ll do a writeup on the event,...
Daily Coping 27 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
2 Simple Yet Effective Medium to Deal with Deadly QuickBooks TLS Error 1.2
Facing TLS errors during the course of working on QuickBooks accounting software is quite...
The 2022 Preview
Comments posted to this topic are about the item The 2022 Preview
OLE DB provider \"SQLNCLI11\" for linked server
We have a DTS package running on one of the production server. This is...
Ask SSC