Browse by Tags

SQL Server 2005 Format Phone Numbers

I have a multi table database that has a bunch of phone number fields in the various tables. I need a stored procedure that i can execute on the DB to scan all tables for the phone number fields and then format the phone numbers to one of two formats depending on the presence of an extension. The format...

Posted to SQL Server 2005 (Forum) by microsoft on 11-27-2009
Trigger to log data changes in XML data type

Below is code that I want to put into a trigger, its very very close to what I want. I need help with the SQL syntax to get what I want. I want 4 rows returned instead of what it returns now, which is 16:( Please remember this is for a trigger, so no cursors or temporary tables if I can avoid it. Duane...

Posted to SQL Server 2005 (Forum) by microsoft on 06-15-2009
Problem: TSQL server, remove all characters after a space (ex: Jon Jr. becomes Jon)

In excel I can split columns like Joe Smith by the space character in between the first and last name. Is there a way for me to remove all characters after a space or . With TSQL? I have a contacts table that is in desperate need of clean up, and one of people have entered stuff like Jon Jr...

Posted to SQL Server 2005 (Forum) by microsoft on 06-09-2009

Page 1 of 1 (3 items)