how to write query in store procedure if one query exicut than 2nd query exicute

After executing the first statement please check for error then based on the success execute the second statement. Use @@error global variable

@@error
After each Transact-SQL statement, the server sets the value of this variable to an integer value:


0 If the statement was successful

Error number If the statement has failed

IF (QUERY1)
BEGIN
QUERY2
END

http://sqltutorials.blogspot.in/2007/06/sql-ifelse-statement.html[^]

BEGIN try
 -- execute your first query 
END try
BEGIN CATCH
return --- if error occur then return
END CATCH
-- execute your second query if no error