Technical Article

Delete constraints - SQL Server 2005

This script will DELETE ALL constraints within the database that you define and in the following order: Foreign Key, Primary Key and then Unique Key.CAUTION:This script does not print out the ALTER TABLE statements, it drop the constraints immediately, therefore backup your database before testing or using this script. I ran the script below and […]

5 (3)

You rated this post out of 5. Change rating

2007-09-19 (first published: )

4,077 reads

Technical Article

Data Dictionary - SQL 2005

I know there are several scripts out there showing you on how to create a data dictionary... I created this script for creating a data dictionary for SQL 2005. It stores the data into a table in the database that you choose. The script only stores the table name, column name, default value of the […]

5 (1)

You rated this post out of 5. Change rating

2006-10-24 (first published: )

3,120 reads

Blogs

SQL Blunders: Stop Writing These Pointless Queries & Write Smarter!

By

They run, they return data. So what? Some SQL queries just waste your time...

Copilot Outside of SSMS Seems to Work

By

I read Brent’s first look at SSMS and Copilot in there. He didn’t have...

A New Word: Falesia

By

falesia– n.  the disquieting awareness that someone’s importance to you and your importance to...

Read the latest Blogs

Forums

T-SQL - except - add date column

By mtz676

SELECT         [A]       --,[Date]       ,  ...

Problem with CASE statement

By water490

Hi Everyone I have used CASE many times but not sure what I am...

Visit the forum

Question of the Day

Calculating Month End

I want to calculate the end of the previous month as a date that I can use in running a report. What is the best way to do this in SQL Server 2022, assuming I have a date stored in @d?

See possible answers