Technical Article

Locate missing columns across entire server

This script will help you locate columns that you provide in a comma delimited format.  You pass it as few or as many columns as you want in the following format: ',,....' and this will generate you a report that states which database, and table each column you passed is in. 

You rated this post out of 5. Change rating

2004-08-13 (first published: )

118 reads

Technical Article

Foreign Key DDL wizard

This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database.  This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP.  It will then generate, and execute, all […]

You rated this post out of 5. Change rating

2004-01-22

235 reads

Technical Article

Generate all database foreign keys

This script will create another script that has all foreign key DDL that exists in a given database.   You only have to run this, and then select the results of this script and paste it into another query window, or if for some reason you have lost your DDL this will enable you to retrieve […]

You rated this post out of 5. Change rating

2003-11-12

229 reads

Blogs

A New Word: Ghough

By

ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection

By

I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets

By

Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs

Forums

How to Pivot daily date to a week Row

By Chris Spencer

I have data as below which is a per day view, I wish to...

SSRS Report Upgrade issue with # Temp tables for 800+ lines of Query

By ralahari

one of the Report which calls two Data sets , Data set1 Contains ,...

How to Implement

By ralahari

Hi Team, I want the sample code to join the Table based on case...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers