Database, Programming, SQL, SQL Server 2000, SQL Tips, Transact-SQL, tSQL, XML

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 Server such as 2008.

Have a look here if you are looking for a working example of passing XML to a stored procedure using SQL Server 2008. Continue reading “SQL Server 2000: Passing a List with XML”

Database, Programming, SQL, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Tips, Transact-SQL, tSQL

SQL Server Rounds FLOATS when Casting to VARCHAR

SQL Server
SQL Server

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. Continue reading “SQL Server Rounds FLOATS when Casting to VARCHAR”

.Net, ADO.NET, ASP.NET, C#, Database, DataSet, DB Connection Example, Example Connection, Programming, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 7, VB.NET

.NET – Write A File to Disk from your Database

ASP.NET
ASP.NET

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. Continue reading “.NET – Write A File to Disk from your Database”