GCSE AQA Programming concepts - AQA Procedures and functions of subroutines Programs are designed using common building blocks, known as programming constructs.

GCSE AQA Further programming language operations - AQA Types of subroutines - procedures and functions Proficient programming requires knowledge of many techniques.

In SQL Server 2014 we saw the introduction of Natively Compiled Stored Procedures. In 2016 we’ll be able to do the same for Scalar User Defined Functions.