T-SQL Programming in SQL Server:-

TSQL program is called “TSQL BLOCK”.

TSQL Blocks are two types:-

(I) Anonymous blocks

(II) Named blocks:                                        

  1. Procedures
  2. Functions
  3. DB triggers

(I) Anonymous Blocks in SQL Server :-

Declare statement :

  • It is used to declare a variable.

Syntax : declare @ varname data type.

Example  :-  

Declare @ X int

Declare @ s varchar(2) ,@ d date time.

Set statement  :-

  • It is used to assign value to a variable.

       Set @ varname = value

       Set @ x=100

Print statement :-

  • It is used to print messages (or) variables.

Print ‘hello’

declare @x int, @y int, @z int

Set @ x=10

Set @ y =20

Set @z=@x+@y

Print ’sum of two nos =’+cast(@z as varchar)