Technical Article

Function Used to Reformat Phone Numbers

Can use this to select , insert and update phone fields into a standard format. Select FormatPhone(phone_column) from table Update Table set phone_column=FormatPhone(phone_column)Where ...Insert Into Table ( column1, phone_primary ...) Values ( 'qwerty', FormatPhone(1455846677)And the like --

2007-01-25 (first published: )

435 reads

Technical Article

Query MSDB for Search String

TSQL:Procedure to Lookup JobsJack Donnell,jack@JackDonnell.com Have you ever kept altering the same query to look for different items in you database?I took a hint from MS with all the sp_help and other system stored procedures and made a two scripts this one to query for databases scheduled tasks or jobs as they are now called.Here […]

2002-06-16

445 reads

Technical Article

Proc to Query MSDB..SYSJOBS and SYSJOBSTEPS

TSQL:Procedure to Lookup JobsJack Donnell,jack@JackDonnell.com Have you ever kept altering the same query to look for different items in you database?I took a hint from MS with all the sp_help and other system stored procedures and made a two scripts this one to query for databases scheduled tasks or jobs as they are now called.The […]

4 (2)

2002-06-07

2,208 reads

Technical Article

Proc to Query Syscomments and Sysobjects

TSQL:Procedure to Query for Dependent ObjectsJack Donnell,jack@JackDonnell.com Have you ever kept altering the same query to look for different items in you database?I took a hint from MS with all the sp_help and other system stored procedures and made a two scripts this one to query for databases dependednt objects or references.I also created another […]

2002-06-07

647 reads

Blogs

Restore HEADERONLY and FILELISTONLY

By

Good day reader.  This post is coming to you from a busy week in...

DevOps From Redgate

By

In a few weeks at the PASS Data Community Summit, I’ll be joining several...

Daily Coping 4 Oct

By

Today’s coping tip is to free up time by canceling any unnecessary plans. I....

Read the latest Blogs

Forums

Bệnh thủy đậu: Nguyên nhân, triệu chứng, biến chứng và cách điều trị

By laciannette

Bệnh thủy đậu là bệnh lành tính, không có triệu chứng nặng nề ngoài...

Where to Buy Sugilite Gemstone for Spiritual healing powers

By bslmgold

Sugilite Gemstone Bertoua Savanna Local Miners (BSLMgold), Sugilite is one of the major love...

How to buy diseased free Ox/Cow Cattle Gallstone

By bslmgold

Bertoua Savanna Local Miners (BSLMgold) After extracting the gallstones from the cattle's intestines they...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers