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

You rated this post out of 5. Change rating

2007-01-25 (first published: )

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

You rated this post out of 5. Change rating

2002-06-16

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

You rated this post out of 5. Change rating

2002-06-07

2,240 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 […]

You rated this post out of 5. Change rating

2002-06-07

648 reads

Blogs

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

PostgreSQL Backup Failure

By

In this blog post I wrote a tip about fixing the PostgreSQL backup failure...

Dynamic Data Masking – SQL Server

By

Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...

Read the latest Blogs

Forums

Need help with the query

By LearningDBA

How do I add 0 in the beginning but the length of the value...

GitHub Copilot - Our Best Ally for T-SQL

By Daniel Calbimonte

Comments posted to this topic are about the item GitHub Copilot - Our Best...

Lead Updates Not Working, Only Rendering Nulls

By Zososql

I hav a table that holds sports betting lines that i am using in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers