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 Simple Example of Finding Records with More than One Entry

2014-05-13

Here is a super-simple example of using a T-SQL query to find records that have more than one table entry.
SQL Server 2000: Passing a List with XML

2014-01-16

SQL Server 2000 is an old database platform now, but it is still fairly widely used. That’s why it’s good to know how to pass a list of parameters to a stored procedure on the SQL Server 2000 database platform. Likewise, the code is forwards compatible and will work with more modern versions of SQL…
T-SQL Find Highly Populated Tables in a Database

2013-11-15

When you are working with an unfamiliar database, such as a third-party SQL Server database, you want to find out which tables actually store the important data. If there is no clean database diagram, then the best option is to write a T-SQL query in SQL Server Management Studio (SSMS). If you are interested in…

recent posts

about

Category: tSQL

T-SQL Simple Example of Finding Records with More than One Entry

SQL Server 2000: Passing a List with XML

T-SQL Find Highly Populated Tables in a Database