Robert Cary

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

Searching Syscomments Accurately

As a SQL Server DBA you should know that your code is stored in syscomments by default. While most DBAs use version control systems, there are times you might want to look through the code on the server for comparison purposes. Robert Cary brings us an article on how you can do this in 2000 and 2005.

4.8 (5)

2008-01-07 (first published: )

7,964 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

5 (1)

2006-10-20 (first published: )

537 reads

Blogs

Updated Pluralsight Course – Kubernetes Installation and Configuration Fundamentals

By

My updated course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want...

Power BI and a Star Schema

By

I sometimes get asked from customers if they should use a star schema or...

A New Git Default Branch

By

I learned a new trick from Andrew Pruski. In a blog on avoiding PowerPoint,...

Read the latest Blogs

Forums

How to write update query to check exist column by value 1 where it exist on tab

By ahmed_elbarbary.2010

How to update check exist column by value 1 where partid exist on table...

User unable to see Logins after recreation of permissions in new instance

By johnylemony

Hello All I was tasked with setting up a new instance on the same...

Monitor SQL Server Error Logs with PowerShell

By WillemG

Comments posted to this topic are about the item Monitor SQL Server Error Logs...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers