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)
949 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)
949 reads
Here is an Excel formula that generates a SQL script from an Excel table
2021-07-30 (first published: 2021-07-26)
2,334 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,603 reads
A note of caution on the use of sp_helptext to script out objects.
2017-09-25
2,735 reads
2017-05-09 (first published: 2017-05-03)
2,822 reads
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
By Chris Yates
It always starts the same way. You open your laptop on a Monday morning,...
Comments posted to this topic are about the item Guidelines and Requirements
Comments posted to this topic are about the item Copying Production Schema
Comments posted to this topic are about the item Workspace Identity Authentication for your...
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers