Justin Cooney

Web Development Tips and Examples

about

I am a Senior Applications Programmer / Analyst with years of experience developing enterprise solutions using the Microsoft technology stack including C#, VB.NET, ASP.NET, AJAX, IIS and SQL Server. I specialize in Web application development with a focus on building secure systems, integrating applications, and designing robust database structures.

Category: tSQL

T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace

2013-05-04

In this article I will review three easy methods that can be used to replace extra spaces between words in a string. Note that if you want to remove extra spaces from the start and end of your string you will still need to encapsulate the output of the routines within the standard LTrim /…
T-SQL – Using the OUTPUT Clause to Get Identity Keys and Log Historical Data

2013-04-30

The OUTPUT clause is a useful part of your T-SQL arsenal that has been added as of SQL Server 2005. You can use the OUTPUT clause in the same vein as @@IDENTITY, IDENT_CURRENT, or SCOPE_IDENTITY(), or even extend it to be a historical logging mechanism. Unlike @@IDENTITY, or SCOPE_IDENTITY(), you need to populate a table…
Search Through SQL Server Stored Procedures in all Databases for a Line of Text

2013-02-07

In an earlier article I explained how to search a SQL server database for Stored Procedures containing some text. This is certainly useful to be able to do, but how about searching all databases on your database server? Being able to create a catalogue of Stored Procedures in all databases on your database server containing…

recent posts

about

Category: tSQL

T-SQL – Replace Multiple Extra Whitespaces in a String with One Whitespace

T-SQL – Using the OUTPUT Clause to Get Identity Keys and Log Historical Data

Search Through SQL Server Stored Procedures in all Databases for a Line of Text