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: )

431 reads

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

437 reads

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,173 reads

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

646 reads

Blogs

How to put a SQL Server Database into Recovery Pending

By

You might be asking why on earth would you want to get a database...

SQL Server on Linux Storage Secrets on Microsoft Channel 9

By

I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...

Daily Coping 29 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Having sum(amount) = 0 returns negatives as well.

By C-M-A

Hello all, I'm trying to get a list of ID's that have a total...

How to limit SQL Job Success events

By Graham Van der vaart

Hi, We have a monitoring tool that reads Windows Event Log entries for Failure...

SQL Server Agent producing unreproducible error

By Thom A

I've built a Powershell script, which I want to run through SQL Server Agent....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers