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-26
25 reads
Andy Robertson
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
2,841 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,305 reads
2017-05-09 (first published: 2017-05-03)
1,405 reads
Blogs
Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering
When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...
Ethics in Modern Data at the Baton Rouge Analytics and Intelligence Network (BRAIN)
By Will Assaf
On July 27, Christine and I will present our joint presentation on Ethics in...
Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8
By todd-32417
With the WordPress 5.8 release, we're starting to introduce features that overall improve your...
Forums
convert hours into decimal
i have a formula that calculates the difference between two dates and tells me...
Get charges percentage per entity\channel
I trying to figure out what percentage of the total charge for a ME...
How to find islands and get max and min range values
I am trying to create groups for each Name and save the max and...
Ask SSC