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)
947 reads
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)
947 reads
Here is an Excel formula that generates a SQL script from an Excel table
2021-07-30 (first published: 2021-07-26)
2,319 reads
Default constraints can lead to assumptions about the values in a column. Combine a check constraint to avoid slip ups.
2018-09-17
4,589 reads
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,696 reads
2017-05-09 (first published: 2017-05-03)
2,788 reads
On May 8, 2025, we hosted our first official event in Switzerland at Prime...
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
I have a record, in those the three columns where firstname / last name...
Comments posted to this topic are about the item Execution Plan Operators
--for a given member if the startdate and endate is continous we need to...
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers