Cloud Database Development and Management

235

Chapter 7

Windows Azure SQL Database

Procedures and Functions

Objectives

◾ Learn programming extensions

◾ Create and use stored procedures, functions, and triggers

7.1 Introduction

Previously, you learned how to create and manage database objects and query information from

a database. You accomplish those tasks by executing SQL statements one at a time. Sometimes,

for more complicated management and query tasks, you may need to execute multiple SQL state-

ments together or run a group of SQL statements repeatedly. A group of SQL statements that can

be executed together is called an SQL procedure. e current standard ANSI SQL does not sup-

port ...