spAddUpdate_Comments
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | INOUT | |
| @SolicitorID | int | IN | |
| @TeamID | int | IN | |
| @CommentDate | datetime | IN | |
| @CommentAuthor | nvarchar(255) | IN | |
| @CommentText | ntext | IN | |
| @Private | bit | IN | |
| @UserPersonalPageID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spAddUpdate_Comments]
(
@PKID int output ,
@SolicitorID int ,
@TeamID int ,
@CommentDate datetime ,
@CommentAuthor nvarchar(255) ,
@CommentText ntext ,
@Private bit,
@UserPersonalPageID int
)
AS
if (@PKID<=0)
begin
INSERT INTO Comments
(
SolicitorID ,
TeamID ,
CommentText ,
CommentAuthor ,
CommentDate ,
Private,
UserPersonalPageID
)
VALUES
(
@SolicitorID ,
@TeamID ,
@CommentText ,
@CommentAuthor ,
@CommentDate ,
@Private ,
@UserPersonalPageID
)
SELECT @PKID = @@Identity
end