Stored Procedure
This training will provides the fundamental knowledge to create robust procedures that improve the performance and security of applications, and the essential skills to write production-quality SQL Server stored procedures. You will gain an introduction to leveraging the programming extensions to the Transact-SQL language. Through hands-on practical exercises.
Content
- Stored Procedure
- Coding a simple retrieval procedure
- Implementing IF-ELSE, WHILE and BEGIN-END blocks
- Declaring and manipulating variables and parameters
- Nesting stored procedures
- Programming error handling logic
