spAddUpdate_Countries
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @Code | nvarchar(6) | IN | |
| @Country | nvarchar(300) | IN |
Definition
Copy
CREATE PROCEDURE dbo.spAddUpdate_Countries
(
@PKID int output ,
@Code nvarchar(6) ,
@Country nvarchar(300)
)
AS
begin transaction
if (@PKID<=0)
begin
INSERT INTO Countries
(
Code ,
Country
)
VALUES
(
@Code ,
@Country
)
SELECT @PKID = @@Identity
end
else
begin
UPDATE Countries SET
Code =@Code ,
Country =@Country
WHERE ID=@PKID
end
commit transaction