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)
837 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,930 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
4,040 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,491 reads
2017-05-09 (first published: 2017-05-03)
2,053 reads
Blogs
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Using ChatGPT for Writing
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Forums
Upgrading from 2016 to 2019 with Encryption
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
NOT LIKE Alternatives in WHERE clause
Hello, I need help to improve an existing (hence I cannot change table's structure...
Vulnerability Assessment removed?
In Brent Ozar's list of links today, I learned that Microsoft has removed the...
Ask SSC