Justin Cooney

Web Development Tips and Examples

recent posts

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

  • SQL Server 2000: Passing a List with XML

    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…

  • SQL Server Rounds FLOATS when Casting to VARCHAR

    A quirk about converting between the FLOAT and the VARCHAR data types in SQL Server is the unexpected rounding that will happen. This is specific to working with the FLOAT data type, and the rounding will not happen when casting a DECIMAL or an INTEGER.

  • .NET – Write A File to Disk from your Database

    In this example I will review and give examples in C# and VB.NET how to get and save a file stored in an Image datatype in a SQL Server table. Here is a link to a list of other articles I have written about using .NET with SQL Server.