1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
| ALTER PROCEDURE [dbo].[USP_SVR_EWTCH_LOG_STATN_STAT]
(
@FileStatusDate DATETIME,
@XMLStatus NTEXT,
@RouteFiles TEXT = NULL,
@TraceFiles TEXT = NULL,
@AddressIPFiles TEXT = NULL,
@BiosXML TEXT = NULL
)
AS
BEGIN
DECLARE @ptrval binary(16),
@XMLLength INTEGER,
@vbData NVARCHAR(4)
IF PATINDEX (N'%</PWS>%', @XMLStatus) = 0
BEGIN
SELECT @XMLLength = DATALENGTH(@XMLStatus)
CREATE TABLE #TableType
(
IDEN INTEGER IDENTITY,
XMLText NTEXT
)
INSERT INTO #TableType
(
XMLText
)
SELECT @XMLStatus
SELECT @ptrval = TEXTPTR(XMLText)
FROM #TableType
WHERE IDEN = 1
SET @vbData = CAST('>' AS NVARCHAR(4))
UPDATETEXT #TableType.XMLText @ptrval @XMLLength 0 @vbData
SELECT @XMLStatus = XMLText
FROM #TableType
WHERE IDEN = 1
DROP TABLE #TableType
END |
Partager