To Assign values to variables in T-SQL programs

To assign values to variables in programs

We can either assign a static value to the variable or load the values of table in to variables also.

Assigning static values

Syntax  : Set @=value

Examples: Set @X=10
                  Set @Y=20

Load the values of table in to variables

Syntax :   Select @=[,....n] from []


Example: Select @S=EName from Employee where EmpNo=1001
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