Skip to main content

Database Programming

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 Programming Overview 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.
SQL Server 2005 Developer Productivity Guided Tour SQL Server 2005 Developer Productivity Guided Tour
Take the tour to discover how the deep integration between Visual Studio 2005 and SQL Server 2005 enables developers to deliver faster results when building data-driven applications.

Database Programming Features

  • 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

    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.