Sample is Null, Not, Between, and, in keywords

Sample is Null, Not, Between, and, in keywords // alter   table  employee  add   ( sal  numeric ( 8 , 2 )) alter   table  employe...

Sample Like Function

Sample Like Function *Like Function select  empid , empname , address , phno , salary , deptname , deptid  from  employee  where  em...

Create Date Time Function in SQL Server

*Create Date Time Function select getdate () as "Date" select getdate () as "Date" select CURREN...

Inner Join,Left Join, Right Join and Create View

*Inner Join select E . empid , E . empname , E . address , E . phno , E . salary , E . deptname , E . deptid from employee E inne...