Conditional Statements in sql server

Conditional Statements

 A block of code that executes baseing on a condition is known as a condtional statement

 These are of two types

   1) Conditional Brancing Statements
   2) Conditional Looping Statements

1) Conditional Brancing

  In conditional branching we will be having multiple block's of code but only a single block of code get's executed sql server supports two conditional branching   statements

      1) if------else if-------else

      2) select case (same as switch case)

2) Conditional Looping

    A loop is a single block of code which executes repeatedly untill a certain condition is met.

        1) While loop

        2) Break inside a while loop

        3) Continue under a while loop
About Author: author 4 + years of Information Technology experience in understanding and analyzing the software and hardware engineering requirements, onsite and offshore management of product development. Expert work on design and development for windows,web,mobile Expert knowledge of C#,ADO.NET, ASP.Net MVC, ENTITY FRAMEWORK, LINQ,COLLECTIONS, JAVASCRIPT,AngularJs 1.0,Angular2, Jquery,Jquery-Ajax, SQL SERVER, XAML,Windows phone 8.1 Good knowledge of WCF-Restful services,WCF, WEB API-Services ,Web- Services,MIcrosoft-Azure,JUICE UI,HTML,CSS,AJAX Read More...

Join him on Google+ | Facebook | Linkedin

No comments