CREATE PROCEDURE My_SP

AS

Delete * From T1//This line make an error because of this table has 
primary key related to the other table T2

IF @@ERROR <> 0
BEGIN
An Error has occured.....
Select Statement.....
END
ELSE
BEGIN
No Error Occured.....
Select Statement.....
END

GO