June 2015
Intermediate to advanced
1800 pages
70h 6m
English
Stored procedures are among the premier features of Microsoft SQL Server. They provide a number of benefits over using ad hoc SQL, including faster performance; restricted, function-based access to tables; protection of application code from database changes; and the ability to simplify complex tasks into a simple stored procedure call.
In the next chapter, you learn how to expand the capabilities of your T-SQL code by creating and using user-defined functions developed in T-SQL.
Read now
Unlock full access