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 ...
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 ...
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 ...
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 ...
