Technical Article

Find possible missing foreign key relationships

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2007-02-26 (first published: )

1,003 reads

Technical Article

Date String format with optional Timestamp

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-01-02 (first published: )

230 reads

Blogs

A Front Door for the DBA Team – AgentDBA UI

By

AgentDBA began as a command line. That suits one DBA on one server, but...

Cleaning Up Azure MS Defender Billing

By

I have a few Azure subscriptions, which are fairly small and not used that...

Installing and Configuring containerd as a Kubernetes Container Runtime

By

This post shows you how to install containerd as the container runtime for Kubernetes...

Read the latest Blogs

Forums

Alamat Telp BCA KCP Kenten (+62) 838-4945-0961

By Halo_BCA

Wa:083849450961 Jl. MP. Mangkunegara Jl. Villa Kenten No.20-21, 8 Ilir, Kec. Ilir Tim. II,...

SQL Server Vector Support II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server Vector Support II

Great Things

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Great Things

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers