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)
871 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
3,069 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,343 reads
2017-05-09 (first published: 2017-05-03)
1,469 reads
Blogs
Daily Coping 18 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure Cosmos DB – HTAP using Azure Synapse Link
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Azure Cosmos DB – HTAP using Synapse Analytics
By sqlroadie
I haven’t done much blogging in the last 6 months. My last article was...
Forums
Event log filling up with Sql error
Windows event log filling up with ERROR 1 : "The activated proc '[dbo].[SqlQueryNotificationStoredProcedure-]' running...
How to do Join
Hello, I am looking for output where EG_RequestID = 175998968 and Reissue from paymentID...
Connect to PostgreSQL as an External Data Source using PolyBase
Comments posted to this topic are about the item Connect to PostgreSQL as an...
Ask SSC