spClone_SiteNotes
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @CloneContentID | int | IN | |
| @ClonedContentID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spClone_SiteNotes
(
@PKID int output,
@CloneContentID int,
@ClonedContentID int
)
AS
BEGIN
BEGIN TRANSACTION
INSERT INTO SiteNotes
(
ContentID,
QueryID,
NoteTopics
)
SELECT
@CloneContentID,
QueryID,
NoteTopics
FROM SiteNotes
WHERE ContentID = @ClonedContentID
SELECT @PKID = @CloneContentID
COMMIT TRANSACTION
END