Return Single Value with ExecuteScalar, Stored Procedures and C#
December 3rd, 2008
A common query is to return a single value from a SQL query such as an aggregate to get the total number of rows in a table. I will show you how to do just that with SQL Server Stored Procedures and C#.
Preparation
You will need some table data to query against. I am using the [...]
Sample Databases for SQL Server
December 2nd, 2008
Microsoft provides some sample databases to use to experiment with your code; because you wouldn’t dare query against your live customer data with untested code right?
Samples
http://www.codeplex.com/SqlServerSamples
SQL Server Database Examples
http://www.codeplex.com/SqlServerSamples#databases
I use the Northwind tables from the SQL Server 2000 Sample DBs.
How to Install the Northwind Sample Database
Unzip the sample database files you just downloaded
Open SQL Server Management [...]
My Essential Developer’s Toolbox – Part I
November 23rd, 2008
This is a multi-part post that lists all of the tools that I use on a regular basis as a web developer. The list is Microsoft Windows centric but I will point out the applications that are cross-platform (as best as I can).
IDEs (Integrated Development Environment)*
Microsoft ASP.NET
Both of the IDEs below are top notch and [...]
mysqldump Similar Utility for SQL Server
November 21st, 2008
If you are using SQL Server (specifically Express 2005) and you are looking for a quick way to export your entire database into a single file, the following tool will do the trick.
Export Your Database
Grab a fresh copy of the free tool.
http://www.eggheadcafe.com/articles/20040913.zip
Once you have downloaded the zip file you can open the pre-built application in [...]
