baxleys.org » nate
Article
Event
Organization
Technology
Project
People
To Do
You are currently only viewing public entries. Login to view all entries.
2 Wiki items tagged 
Log In to access RSS feeds.
code + mssql
Search and Replace All TablesSearch and replace all occurances of a string in all tables in a database.
From http://vyaskn.tripod.com/
--To replace all occurences of 'America' with 'USA':
EXEC SearchAndReplace 'America', 'USA'
GO
From http://vyaskn.tripod.com/
--To replace all occurences of 'America' with 'USA':
EXEC SearchAndReplace 'America', 'USA'
GO
Search All TablesSearch all text fields across all tables in a database. Taken from http://vyaskn.tripod.com/
--To search all columns of all tables in Pubs database for the keyword "Computer"
EXEC SearchAllTables 'Computer'
GO
--To search all columns of all tables in Pubs database for the keyword "Computer"
EXEC SearchAllTables 'Computer'
GO
Log In to access RSS feeds.
baxleys.org
