Saw Mike's routine for counting occurences of a string in a string and I thought I'd offer a simpler solution.Simply replace the occurence with null and use length differences as shown.NOTE: len may ignore trailing spaces, so this can be made more solid by adding some non printable char (less likely to interfere with operation) […]
2004-03-10
90 reads
This function will return the number of occurrences of one string within another string. I was looking for something like this recently, and the only thing I could find was needlessly complicated. Don't forget, when calling a scalar function, you must qualify with username like this:Select dbo.StringCount('Hi There','e') This function may be a little too […]
2004-03-09
350 reads
This script is used to disconnect all connections by a particular individual to a server. I use it when I have to disconnect somebody and they have too many processes to do it by hand. Normally, you can just connect the offending process, but if there are multiple processes that are causing a problem , […]
2004-03-08
2,868 reads
Found a version of this on the net. removed the loop and if/thens and made it a case statement 2004-03-11: Changed '@%@' to '%@%@%'
2004-03-08
426 reads
This function returns the difference between dates in the H:MM:SS format.
2004-03-05
274 reads
This sp will return the column names for a table(s) and form a "Select Statement" for a table(s). We can pass a table name as a parameter to display a "Select Statement" for that table.
2004-03-04
121 reads
2004-03-04
153 reads
This is an update to sp_helpindex, it allows you to pass the table name and whether you want to retrieve clustered, nonclustered or primary key indexes for a table. Using the sp_msforeach table will allow you to do this for all tables in a database. Inserting the data into a table will allow you to […]
2004-03-04
1,029 reads
This script creates a stored procedure that archives the sql server error log. It uses the startup parameters stored in the registry to locate the errorlog.1 file and then copies the errorlog.1 file to errorlog.log.
2004-03-02
349 reads
This Script takes any table wich contains rows with names and valus and converts it into a result set with the names as collumn names and the values as values.Just set @TableName,@vcName,@vcValue to the desired values.
2004-03-02
203 reads
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Wa:0821-4447-7715 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa Tengah...
Wa:0821-4447-7715 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta 55223
Comments posted to this topic are about the item A Quick Second Opinion
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers