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: SQL Server 2000

T-SQL to Enforce Proper Case Capitalization

2015-09-30

This handy-dandy T-SQL query will take any input string and capitalize the start of each word within the string. It will also enforce proper use of lower-case throughout the string without affecting query performance too severely. This query assumes that you are working with titles, user names, or place names where you want to make…
Basic Example of using the ASP.NET FileUpload to Save into a Database

2014-07-13

Here is a super-simple bare-bones example of an ASP.NET Web form page in C# that uses the .NET FileUpload component to allow a user to upload a file into a SQL Server database table. I’ve put this together as a template to show just how easy it is to do and how few lines of…
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.

recent posts

about

Category: SQL Server 2000

T-SQL to Enforce Proper Case Capitalization

Basic Example of using the ASP.NET FileUpload to Save into a Database

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