Friday, May 10, 2019

Loops in Stored Procedures

Whenever we execute a procedure each query or statement is executing once. 
Loop is a programming concept which is used to execute a group of statements repeatedly for the specific no of times.

 3 Types of Loops :-
- Simple Loop
- For Loop
- While Loop

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Window Functions in SQL

Window functions perform calculations across a set of rows related to the current row without collapsing the rows into a single result. Unli...

  • Update Strategy Transformation
    Update Strategy Transformation is Connected and Active transformation. It is used to insert, update, delete and reject records from a file ...
  • Session parameters & Session variables
    Session Parameter :- ---------------------- Session parameters, like mapping parameters, represent values you might want to change betwee...
  • Analytical Functions
    The functions SUM, COUNT, AVG, MIN, MAX are the common aggregate functions the result of which does not depend on the order of the records....