Justin Cooney
Web Development Tips and Examples
Category: SQL Tips
-
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…
-
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…
-
There are times when it comes in handy to be able to query all columns of all of the tables in a database for a particular text match. For example: if you have just taken over a project with a large database and are trying to find where values from the UI are coming from,…
Justin Cooney 