Table Generator for defined tables
This script will generate a format friendly ddl statement for a predefined table in sql server.
2010-05-19 (first published: 2009-06-03)
1,900 reads
Ryan Foote
2009-07-06 (first published: 2009-06-23)
4,650 reads
Blogs
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Creating a Flyway Desktop Shadow Database in PostgreSQL
By Steve Jones
In order to generate migrations, we need to configure Flyway to use a shadow...
Daily Coping 6 Feb 2023
By Steve Jones
Today’s coping tip is to get back in contact with an old friend. This...
Forums
Future of SQL Server DBA Role
I would like to know what certifications or paths to choose in order to...
Extended Events shows each SQL command in one long line
Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...
Group by issue
Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...
Ask SSC