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 – Search a Database for all Table Columns with a Text Value

2013-01-03

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,…
SQL Server – Pass a List from your ASP.NET Code to a Stored Procedure using XML

2012-12-31

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…
SQL Server: T-SQL to Show Table Column Information

2012-12-07

Sometimes using the SSMS GUI table designer is a hassle when compared with directly querying the table structure using a simple SQL statement. For example if you are right in the middle of editing a stored procedure and want to know the data types and sizes of some columns for a table or two, then…

recent posts

about

Category: tSQL

T-SQL – Search a Database for all Table Columns with a Text Value

SQL Server – Pass a List from your ASP.NET Code to a Stored Procedure using XML

SQL Server: T-SQL to Show Table Column Information