USE [appuals] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[sp_temp] AS BEGIN SET NOCOUNT ON; SELECT * from dbo.temp; END The output will be as below. Using the DROP IF ...