spBulkUpdate_EmailLink
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EmailID | int | IN | |
| @XML | ntext | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spBulkUpdate_EmailLink]
(
@EmailID as int,
@XML as ntext
)
AS
IF @EmailID >0
delete from EmailLink
where EmailID = @EmailID
DECLARE @idoc int
EXEC sp_xml_preparedocument @idoc OUTPUT, @XML
INSERT INTO EmailLink(EmailID, PID, URL, DocumentID)
SELECT EmailID, PID, URL, DocumentID
FROM OPENXML (@idoc, '/rows/row', 0)
WITH (EmailID int,
PID int,
URL nvarchar(4000),
DocumentID int
)
EXEC sp_xml_removedocument @idoc