spUpdateAttributeType_SitePoll
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @AttributeTypesID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spUpdateAttributeType_SitePoll
(
@PKID int OUTPUT,
@AttributeTypesID int
)
AS
DECLARE @Return int
SET @Return = 0
BEGIN TRANSACTION
IF (@PKID<=0) BEGIN
SET @Return = -1
END
ELSE
BEGIN
UPDATE [SitePolls]
SET [AttributeTypesID]=@AttributeTypesID
WHERE ID=@PKID
IF (@@ERROR <> 0) SET @Return = @@ERROR
END
COMMIT TRANSACTION
RETURN @Return