You are currently only viewing public entries. Login to view all entries.
4 Wiki items tagged
code + sql
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
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
Order characters numericallyIt may be simple, but this SQL will order items numerically (1,2,3,10,20) instead of alpha (1,10,2,20,3).
SQL Permissions ScriptGenerate a Script to Grant Permissions on all items to WebUser group