CHILD_RECORD_FOUND Equivalent in SQL Server

HI All..,,

for CHILD_RECORD_FOUND in Oracle , in SQL Server is Error_number = 547


begin try
---------
----------
end try
 begin catch 

     if @errornumber = 547
     print 'Unable to delete Parent , as child record exists'
 end catch



for 547 ===> delete statement conflicted with the reference constraint

LOCKS Information in SQL Server

http://www.informit.com/articles/article.aspx?p=327992&seqNum=8

Extract Time from given Date in SQL Server

Hi guys,

To extract the exact time from from given date as shown below:


Select cast(getdate() as time) [time]

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.  
               );