Do you want to learn about SQL Server database programming? Check out the resources here to learn how to program against SQL Server using data access technologies such as SQL CLR, T-SQL, and XML.
SQL Server Database Programming Overview Application programming interfaces (APIs) are the mechanisms used by applications to access resources on the local computer or available through a network. Microsoft SQL Server 2005 supports several classes of APIs that applications can use to access SQL Server resources.
Programming SQL Server 2005 Using the .NET Framework Microsoft SQL Server 2005 features the integration of the common language runtime (CLR) component of the .NET Framework for Microsoft Windows. This means that you can now write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.
Data Access and Storage Developer Center Find all that's new on data technologies, including ADO.NET, SQL Native Client, MDAC, and more, as well as start-to-finish guidance in using these technologies to create powerful solutions.
Transact-SQL has long been the basis for all database programming in SQL Server. SQL Server 2005 provides many new language capabilities for developing scalable database applications. These enhancements include error handling, new recursive query capabilities, and support for new SQL Server Database Engine capabilities.
SQL Server 2005 XML Advancements such as the native XML data type and XQuery help you seamlessly connect internal and external systems. SQL Server 2005 supports both relational and XML data natively, so you can store, manage, and analyze data in the format that best suits your needs.