SQL stored procedures in Windows Azure SQL database

Using stored procedures in Windows Azure SQL database is a conventional wisdom. Store procedures typically run faster than Adhoc SQL statements. The reason for this is that they are pre-compiled and SQL Server has generally a good idea about the execution plan it needs to take. Another advantage is that with stored procedures, you can use input and output parameters. You can call one store procedure from within another procedure. One of biggest benefit of using stored procs is code reuse, the concept you build it once and use it over and over again maybe from different application or interfaces. The Transact or TSQL code within the store procedure will run together as a unit and is typically used to do certain tasks like outputting a certain report, returning some sort of value back to the client application or at the very least execute a collection of SQL statements together as a batch. We are going to show you a simple example of using stored procedure utilizing Windows Azure SQL database.

The SQL Azure Tutorials and SQL scripts told me exactly what I needed to know and helped me get the job done. Did not spend days online reading about it, followed along and just did it! Awesome training!!