How to search a word contains procedure in SQL Server...

SELECT *
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%test%';

RAISEERROR in SQL Server......

declare @ErrorMessage varchar(1000) = error_message()

declare @ErrorSeverity int =error_severity()

declare @ErrorState int = error_state()

RAISERROR (@ErrorMessage, -- Message text.  
               @ErrorSeverity, -- Severity.  
               @ErrorState -- State.  
               );  

Previous Month First day in SQL Server

Previous Month First day...

CONVERT(DATETIME, CONVERT(VARCHAR(7), dateadd(m,-1,GETDATE()), 120) + '-01')

Extract Day, Month, Year from date

Hi guys..,

Oracle	SQL Server
SELECT to_char(sysdate,'dd') FROM DUAL;	select day(getdate())
SELECT to_char(sysdate,'mm') FROM DUAL;	select month(getdate())
SELECT to_char(sysdate,'yyyy') FROM DUAL;	select year(getdate())

Oracle's Median in SQL Server

Hi All...,

Here is the equivalent function for Oracle's Median in SQL Server..

Oracle	SQL Server
select deptno,median(sal) from emp group by deptno	select * from (select distinct e.deptno, PERCENTILE_CONT(0.5)  within group(order by e.sal) over(partition by e.deptno)  as median_sal from emp e)  as a   where a.deptno is not null