2011-10-03 (first published: 2008-03-27)
5,915 reads
Robert Cary
- Interests: Sleight of hand magic, cycling, bowling, poker
Search All Columns in all tables
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
2007-01-23 (first published: 2007-01-04)
2,940 reads
Find Nth Occurrence of Character Function (Set Based)
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
2006-10-20 (first published: 2006-09-18)
540 reads
Blogs
Daily Coping 7 Dec 2022
By Steve Jones
Today’s coping tip is to stop for a minute when you walk outside and...
Encryption and Data Protection Regulation
One of the reasons you may be considering encryption is due to the relevant...
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
Forums
Blocking
We were getting constant blocking on the db server. However, after stopping the process...
Either/ Or Query
Hi, I have a table containing some columns and some simple data. I want...
Ask SSC