baxleys.org » nate
Article
Event
Organization
Technology
Project
People
To Do
You are currently only viewing public entries. Login to view all entries.
6 Wiki items tagged 
Log In to access RSS feeds.
sql
Search through text of Stored ProcedureSearch across the text of all stored procedures for a particular string.
Long character fields from database weird in PHPWhen you are returning longer text, like from a varchar(MAX) or such you get weird characters at the end.
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
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
Log In to access RSS feeds.
baxleys.org
