It's kind of hard to explain what it is the OP is trying to .. understand. But given the apaucity of TSQL in the question I'd formulate that THAT'S what the question actually is. So ... look for stuff related to these things, here in CPQA, using google, even the BOL:
USE [database]
GO
CREATE TABLE [xml].[tblXMLDocBulkInserted](
[xmliform] [nvarchar](max) NULL
) ON [PRIMARY]
BULK INSERT [database].[xml].[tblXMLDocBulkInserted]
FROM 'c:\users\cpqa\js\xmlDocument.xml'
CREATE TABLE [xml].[tblXMLDocBulkInsertedIdx](
[Idx] [int] IDENTITY(1,1) NOT NULL,
[xmliform] [nvarchar](max) NULL
) ON [PRIMARY]
INSERT INTO [database].[xml].[tblXMLDocBulkInsertedIdx]
SELECT * FROM [database].[xml].[tblXMLDocBulkInserted]
SELECT [Idx]
,[xmliform]
FROM [20121212151401555].[xml].[tblXMLDocBulkInserted]
GO
SELECT * FROM [database].[xml].[tblXMLDocBulkInsertedIdx]
WHERE [xmliform] LIKE '%>%<%'
In this return you'll see a list of all those good things found in a "schema". It's easy to see that there's data "contained" by it. Compare this result to the original input document.
On the other hand, then, there's some data here (perhaps):
SELECT * FROM [database].[xml].[tblXMLDocBulkInsertedIdx]
WHERE [xmliform] NOT LIKE '%<%'
Submit an article or tip