Titlebook: SQL Server 2000 Stored Procedures Handbook; Tony Bain,Louis Davidson,Chuck Hawkins Book 2003 Tony Bain, Louis Davidson, Robin Dewson, and

责任

Blasphemy

标准

Common Practices with Stored Procedures,In the previous chapters, we discussed the benefits, disadvantages, and the syntax of stored procedures. In this chapter, we will focus on the purposes of stored procedures within our applications. Here’s an outline of what we intend to discuss:

FRET

audiologist

Security,By now you will have realized that using stored procedures is the best way for making data available from an SQL database. In the earlier chapters, we have seen that there are several reasons for preferring this approach. One such major reason is security. In this chapter will examine this aspect of SQL Server stored procedures.

钉牢

Ancillary

幼稚

违抗

User Defined Functions,perhaps, the least used of specialized stored procedures, they are powerful tools in a database developer’s armory. They provide the developer with the ability to create their own customized functions, which can then be re-used in other parts of their T-SQL code.

Matrimony