Robert Cary

Interests: Sleight of hand magic, cycling, bowling, poker

All authors

URLEncode

by Robert Cary

SQLServerCentral.com

Here is a short UDF to URL encode a string. Requires a numbers table.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(5)

You rated this post out of 5. Change rating

2011-10-03 (first published: 2008-03-27)

7,208 reads

Discuss

Search All Columns in all tables

by Robert Cary

SQLServerCentral

Miscellaneous

This script will quickly generate DML to search all the tables in the current database for a given string. It could be modified to execute the generated code if desired. If you are running this in a

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-01-23 (first published: 2007-01-04)

2,980 reads

Discuss

Find Nth Occurrence of Character Function (Set Based)

by Robert Cary

SQLServerCentral

This function was originally contributed by other visitors. Below is an example of a set based approach to the problem. This script requires a numbers table (see SqlServerCentral article http://www.sqlservercentral.com/columnists/mcoles/2547.asp for more details)Please note that this code is uses SQL2005 featuresEnjoy!Robert Caryhttp://tsqlland.blogspot.com