Microsoft SQL Server 2005 Programming For Dummies
Chapter One
The Joy of SQL Server
2005 Programming
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
SQL 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 200 ... read full excerpt from Microsoft SQL Server 2005 For Dummies ebook
