CREATE PROCEDURE PROCNAME
@CountryId integer ,
@CountryName VARCHAR(200) ,
@nType integer
AS
BEGIN
IF @nType=1
INSERT INTO Country VALUES(@CountryId,@CountryName);
ELSE IF @nType=2
UPDATE Country SET CountryName=@CountryName WHERE CountryId=@CountryId;
ELSE IF @nType=0
DELET FROM Country WHERE CountryId=@CountryIdEND