This procedure is intended for single column primary key relationships.First we will create two table functions. The first finds a list of all tables with their primary key columns. The second finds all existing foreign key relationships with their table and column names. Finally we find all tables with primary key column names that do […]
2007-02-26 (first published: 2006-11-17)
866 reads
Use this script to figure out the current age of a person or object. It also takes leap year birthdates into consideration. You can also use this to find out the age of something at a particular point of time.
2007-01-04 (first published: 2006-12-19)
183 reads
I find it so annoying to format dates. Sometimes I want to include the timestamp, but if it is a midnight time stamp, the time is irrelevant. Sending in a datetime will return either the date string or a date string with a timestamp up to the seconds with either AM or PM.
2007-01-02 (first published: 2006-12-20)
168 reads
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Our IT department contacted me recently and asked if they should change the default...
Hi there, I'm on a team developing an enterprise data warehouse for our organization....
Comments posted to this topic are about the item PostgreSQL Copy
Ask SSC