Justin Cooney
Web Development Tips and Examples
Category: SQL Server 2008
-
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,…
-
Sometimes while developing a tool, a developer needs to pass a list of values with a variable size to their database. There are several ways of doing so, one of which involves passing the list in XML format. The introduction of SQL Server 2005 offered the use of XML datatypes, which had not existed in…
Justin Cooney 