CREATE TABLE GG_TEST (ID INT, XMLL NTEXT)

INSERT INTO GG_TEST VALUES (1,'<ROOT>SAM</RoOT>')

CREATE FUNCTION ISXML(@XMLDOCUMENT ntext) RETURNS INT
AS
BEGIN

	DECLARE @XMLDOCUMENT_XML XML
	SET @XMLDOCUMENT_XML = @XMLDOCUMENT
	RETURN @@ERROR

END
GO

CREATE TRIGGER trg_GG_insupd
ON dbo.GG_TEST
AFTER INSERT, UPDATE
AS
BEGIN
	SET NOCOUNT ON
	BEGIN TRY
			BEGIN TRY
				
				DECLARE @T TABLE ( ID INT)
				INSERT INTO @T
				SELECT	dbo.ISXML(GG_TEST.xmlL)
				FROM	INSERTED I
							INNER JOIN	GG_TEST (NOLOCK)
								ON I.ID = GG_TEST.ID
			END TRY
			
			BEGIN CATCH
					
			END CATCH
		
		END TRY
		
		BEGIN CATCH
		
		END CATCH


	
END
GO

UPDATE GG_TEST SET ID = 2