spAddUpdate_SiteCodeTables
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @Name | nvarchar(256) | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_SiteCodeTables]
(
@PKID int output,
@Name nvarchar(256)
)
AS
set nocount on
if (@PKID<=0)
begin
INSERT INTO [dbo].[SiteCodeTables]
(
[Name]
)
VALUES
(
@Name
)
SELECT @PKID = @@Identity
end
else
begin
UPDATE [dbo].[SiteCodeTables]
SET
[Name] = @Name
WHERE ID=@PKID
end