SQL Server XML

Hi I want to store data about customers. I was thinking of using something like CustomerID            int CustomerData        xmltype But I was wondering if this is a good idea because I want to complex ...

I have an XML file that is hosted on a mainframe web server.  I need to read the file via a URL and import this into my SQL database. I'm fairly new to SQL 2005 but this seems to be a simple task.  I've looked ...

Dear SQLXML specialists and other animals, I got the following SP, that runs a SQL statement with FOR XML EXPLICIT: **** SQL STATEMENT ***** CREATE PROCEDURE SP_F06_GetActions (     @MSISDN            as varchar(20), ...

Hi All, I'm trying to select data out from an xml type.  One of my elements is cdata wrapped and when I select it I'm getting the resulting cdata wrapper rather than the data by itself.  I've included my sql and the results I see below. ...

There does not appear to be any way to specify the SQL Server data source with a non-standard port when setting up an SQLXML virtual directory.  I tried appending ",portnumber" to the server name and got the error "Invalid ...

Hi, I'm using SQL Server 2000 and I'm having some dificulties to produce the rigth xml document using the FOR XML clause of SELECT. The SELECT that I'm using is the following: select 1 as Tag, NULL as Parent, Header.TaxRegistrationNumber as ...

Goal:  Insert up to 10,000 rows to a table--ideally < 5 seconds or faster. Table Info:  10 columns, some varchar(50), a couple ints, one datetime with default.  Overall, pretty small row. Table Size:  This table may have between 10,000 and 2 million (perhaps up to ...