Hi.
try this:
IF EXISTS (
SELECT *
FROM Emp
)
DROP PROCEDURE <
GO
CREATE PROCEDURE [dbo].[Insert](
@Name nvarchar(50),
@Address nvarchar(100),
@Email Nvarchar(20),
@Mob nvarchar(20)
)
AS
begin
insert into Emp(Name , Addres,Email,Mob)
values (@Name,@Address,@Email,@Mob)
end
GO
-- if it is helpful please vote.--