SQL Sub Programming IF Case Condition
SUB-PROGRAMS
A Sub-Program is a new block of code which can be reused. We have 2 types of Sub-Programs in SQL Server:
1. Procedures
2. Functions
Procedures:
• A stored procedure is a saved collection of Transact-SQL statements or a reference to a Microsoft .NET Framework common language runtime (CLR) method that can take and return user-supplied parameters.
• Procedures can be created for permanent use or for temporary use within a session, local temporary procedure, or for temporary use within all sessions, global temporary procedure.
• Stored procedures can also be created to run automatically when an instance of SQL Server starts.
On this page of the site you can watch the video online SQL Sub Programming IF Case Condition with a duration of hours minute second in good quality, which was uploaded by the user Software Traininings 19 June 2024, share the link with friends and acquaintances, this video has already been watched 22 times on youtube and it was liked by 2 viewers. Enjoy your viewing!
