EXCEPTION HANDLING IN SQL ?

Select *from EMPLOYEES

--CREATE TABLE TEST

--(

--   ID INT,

--   [NAME] NVARCHAR(10)

--)

SELECT ID,[NAME] FROM TEST

INSERT INTO TEST([NAME],ID) VALUES('SHYAM',88)

--Using Distinct Keyword to select Unique records

SELECT DISTINCT ID,[NAME] FROM TEST

--select records using where clause

SELECT ID,[NAME] FROM TEST WHERE ID=20

--select records using where AND/OR Clause

SELECT ID,[NAME] FROM TEST WHERE ID=20 AND [NAME]='RAM' OR [NAME]='SHYAM'

--select records using where IN Clause

SELECT ID,[NAME] FROM TEST WHERE [NAME] IN ('RAM','SHYAM')

--select records using where BETWEEN Clause

SELECT ID,[NAME] FROM TEST WHERE ID BETWEEN 55 AND 99

--select records using where LIKE Clause

SELECT ID,[NAME] FROM TEST WHERE [NAME] LIKE '%YAM%'

--select records using Order BY Clause

SELECT ID,[NAME] FROM TEST ORDER BY 2 DESC

--select records using Group BY Clause

SELECT SUM(ID) ID,[NAME] FROM TEST GROUP BY [NAME]

--select records using Count Clause

SELECT COUNT(ID) ID FROM TEST

--select records using MAX Clause

SELECT MAX(ID) ID FROM TEST

--select records using Having Clause

SELECT ID FROM TEST GROUP BY ID HAVING MAX(ID)>20

CREATE INDEX INDEX_TEST_ID

ON TEST(ID)

ALTER TABLE TEST

DROP INDEX INDEX_TEST_ID ON TEST  --- DROP INDEX FROM TABLE

--------EXCEPTION HANDLING-----------

 BEGIN TRY

SELECT *FROM TEST

DECLARE @A INT = 1;

DECLARE @B INT = 0;

DECLARE @C INT = 0;

SET @C = @A/@B;

END TRY

BEGIN CATCH

PRINT 'CATCH'

END CATCH