Wiley Microsoft SQL Server 2005 For Dummies 978-0-7645-7755-0 ユーザーズマニュアル

Transact-SQL templates

In SQL Server Management Studio, you can find many templates to help you
carry out common tasks with Transact-SQL. To view the range of T-SQL tem-
plates, choose View➪Template Explorer in SQL Server Management Studio.
The Template Explorer displays. View the nodes to see the range of templates
available. Check out Chapter 5 for more on templates.

Other Developer-Orientated

Enhancements

SQL Server 2005 has several new developer-orientated enhancements. I
describe those in the following sections.

Support for the Common 

Language Runtime

The Common Language Runtime (CLR), which is used by .NET code, is
embedded in the SQL Server 2005 database engine. You can write stored pro-
cedures, triggers, functions, aggregates, and user-defined datatypes by using
languages such as Visual Basic .NET or C#. Stored procedures written in a
.NET language are a good replacement for SQL Server 2000 extended stored
procedures, because you can specify a security level for the .NET code.

You find three security levels for .NET code:

⻬ Safe: This level allows no access outside SQL Server. For example, your

code cannot access the file system, registry, environment variables, or
the network. This security level is the most secure.

⻬ External Access: This security level allows limited external access by

your code. Specifically, you can access the registry, the file system, envi-
ronment variables, and the network.

⻬ UnSafe: You can access any desired functionality outside SQL Server

2005 with the UnSafe security level. You should use the UnSafe security
level only if you are certain that the code is well written and you trust
the author of the code.

24

06_577557 ch02.qxp  12/20/05  9:43 PM  Page 24