SQL Few Drawbacks and Trasact SQL Introduction


Trasact SQL

 SQL have few drawbacks in it

 It doesnot provide conditional branching and conditional looping statements.

 It doesnot providse proper error handling mechanisums

The above features are generally provided under procedural programing languages like c,To provide the similar features under data bases sql is cominded with proceudral capabilities and introduced as T-SQL(Transact-SQL) aslo known as PL/SQL in other databases like ORACLE

T-SQl is about programing where we will writing the code here in the form of programs

T-SQL prograns are of two types
 
   1) ANONYMOUS BLOCKS

        A Anonymous block is a block of code written as a program on a specific machine with a scope of the session.If we define these programs on the machine they can         be executed on the same machine but not on any other machine

   2)SUB PROGRAMS

        A Subprogram is a named block of code whihc is directly saved on the server so that it can be executed any time we want and from any machine connected to the         server

               Sub Programs are Three types
   
               1) Stored Procedures
               2) Stored Functions
               3) Triggers
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

1 comment