Wiley Microsoft SQL Server 2005 Programming For Dummies 978-0-471-77422-8 Manuel D’Utilisation

In This Chapter

䊳

Choosing the right SQL Server edition for your programming goals

䊳

Gathering and manipulating data

䊳

Enforcing business rules for your database

䊳

Ensuring SQL Server security

䊳

When Transact-SQL isn’t enough

S

QL Server 2005 builds on the existing strengths of SQL Server 2000 to
help you build applications that retrieve and manipulate data to suit

your business needs. SQL Server 2005 continues to support Transact-SQL 
(T-SQL) as the primary language for the manipulation of relational data but
has also added new functionality to allow you to work better with XML and 
to use .NET languages in your applications.

SQL Server 2005 allows you to flexibly create powerful applications based 
on its relational tables. Traditionally, you had to use Transact-SQL for those
applications, and often that remains the programming language of choice.

When you create applications based on SQL Server 2005, you need to con-
sider the goals of your programming before you do any coding. In this chap-
ter, I discuss how you can define your programming goals and gather and
manipulate data in SQL Server 2005. A well-designed SQL Server 2005 applica-
tion enforces the business rules that your company has defined. If your data
is automatically checked for conformity to those rules, you can have increased
confidence that the application supports your business objectives.

05_774228 ch01.qxp  2/27/07  2:33 PM  Page 9