Following article demonstrates the steps involved in configuring a trusted SQL Server connection to access data using ADO.NET

Pre-requisites

1.   A local instance of SQL Server has to be setup on the same machine as the IIS

2.  Optionally, during setup, the SQL server must be configured to be accessible thro’ Windows Authentication Mode. (It doesn’t matter if you haven’t done so)  

This chapter and the next describe the most important Transact-SQL statement - SELECT. In this chapter you will learn how to use the SELECT statement to perform simple queries. Every clause in this statement is described, and numerous examples using our sample database are given to demonstrate the practical use of each clause. The second part of this chapter introduces aggregate functions and the UNION operator.

If you have installed SQL Server 2000 or ever worked with it, you would have noticed some databases that are common to all installations of SQL Server. These databases are mostly not worked upon by the users of the database; the reason for this is that these databases are mostly being used by SQL Server 2000 itself for its various operations. Such databases are called as System Databases. This article gives you an overview about role of the system databases in SQL Server

If you've recently been charged with setting up a Web server to interact with SQL Server, your choice of development environments probably comes down to Active Server Pages (ASP) or Allaire ColdFusion. A SQL Server Magazine Instant Poll showed that more SQL Server developers use ASP than ColdFusion (you can find the results at http://www.sqlmag.com/Poll/Main.cfm?QID= 99&Action=PreviousPoll). But ColdFusion is a powerful tool that offers a viable alternative to ASP, as I'll demonstrate in this article by using examples from my experience as Web technology manager for SQL Server Magazine and Windows 2000 Magazine.

If you have worked with SQL Server, you are probably familiar with identity columns. These are equivalent to the "AutoNumber" columns in Access. The main purpose of these columns is to provide a primary key to the table, when a primary key can not be defined using other fields in the table. One of the common questions in the newsgroups is "How can I get the ID of the inserted record in SQL database?" This translates to "How can I get the value of identity column in the inserted record?" In this article, we will see how we can do this in several ways. Also, we will learn a little bit about the columns themselves.