SQL Server XML

Okay, I'm sure this is something relatively simple, but I can't find a decent tutorial or example anywhere to work from. What I'm trying to do is this.  I have a current database(Access/SQL) that contains all of my companies real estate properties, floorplans, ...

Hi all-- I have a "complex" replication process that eventually passes on XML documents to be inserted (via trigger from the subscriber table) into an XML-typed column which has a schema collection assigned. 99.99% of the time this works with no problems (the XML is well-formed ...

I am familiar with using sql server but this is my first look at xml and I am confused. I have a database extract in the form of an xml file and I would like to import the file into a blank database and creating tghe table and ...

Hi, I am trying to import an XML file into a SQL2000(SP4) database, using the SQLXML(3.0 SP3) bulkload facility. The problem I am having is that SQL is stripping the LF and CR characters from the data on import. I ...

Hi, We have a simple web application, classic ASP (VBScript) based, which uses XML-explicit stored procedures for most of its data transfer functions. The application has been running a-OK for 2 years+ on a Windows 2000- based web server and SQL Server 2000 database. ...

I am doing an insert using parameters from vs05 to sql05 The data is going into an XML column.   SqlCommand cmd = new SqlCommand();         cmd.CommandText = "web.SurveyProfiles_upd";         cmd.CommandType = CommandType.StoredProcedure; ...

I have a fixed length string, which contains several parts, from 1st to 8th characters is code, from 9th to 10th as type, ........ So, I don't SQL XML feature can or not to process this mapping string. ...