Database Programming in SQL Server :-

  • To do database programming SQL statements must be embedded in TSQL block.
  • The following SQL statements can be embedded in TSQL block.

(I) All DML commands

(II) All TCL commands

(III) DRL command

  • Syntax of the select statement:

Select @ var1=col1, @var2=col2 ——– from <tabname> [where<condition>]

Example   :    Select @ eno=empno, @ename=ename from emp where empno=7369

                              Select @sal=sal from emp where,empno=@eno

                              Print  ‘employee earning’ +cast (@sal as varchar)

Write a program to input an employee number & calculate the employee experience.

                    Declare  @eno int,@doj datetime

                    Declare @ expr int

                    Set @ eno =7566

                    Select @doj=hiredate from emp where empno=@eno

                    Set @expr=abs (datediff(yy,setdate() ,@doj))

                   Print ‘employee working since ‘+ cast(@expr as varchar)+’years’

                   Output  → employee working since 28 years.