Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 What is SQLXML?

Author  Topic 

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-01-08 : 18:01:40
Hi team! We are setting up a new SQL 2000 / Win2kAS machine to which we will begin testing/migrating. One of our server admins found this link at Microsoft ([url]http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/msdn-files/027/001/602/msdncompositedoc.xml[/url]) about SQLXML, and asked if we need/want it. Do any of you have any input on this thing? It appears to add a little functionality, but we are not yet doing much in the way of XML at all. I don't understand what "Updategrams" are that this page talks about.

I'm tempted to say, NO we don't care about it, at least not yet. Any input?

TIA

--------------------------------------------------------------
1000 Posts, Here I come! I wonder what my new title will be...

Garth
SQLTeam Author

119 Posts

Posted - 2002-01-08 : 18:10:37
If you are not doing anything with XML you do not need it.

If you want to learn about SQL Server's support for XML, including Updategrams, you can read Appendix D listed on this page:

www.sqlbook.com/code_centric--sample_chapters2.html

The appendix provides a brief intro to XML, shows how to setup SQLXML, and how to create ASP that uses Updategrams to modify data.

Garth
www.SQLBook.com
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-01-08 : 18:10:50
Hey Mark

Basically it is a provider like SQLOLEDB for leveraging SQL Servers XML features in your code.

Here is the MS site for it http://www.microsoft.com/sql/techinfo/xml/default.asp
and a good resource here http://www.sqlxml.org/

If you are not doing much XML then you can leave it off no worries.

Damian
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2002-01-08 : 18:12:02
Damn, 13 seconds....

ya gotta be quick around here



Damian
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-01-08 : 19:33:21
You guys are AWESOME! I knew you'd have the answer. Thanks for the chapter link Garth. It looks like maybe I should get your book too.

------------------------------------------------------------
Counting down the posts.... Only 2 to go. The anticipation builds... What will the new title be? Looks like a good time for an extended vacation.
Go to Top of Page
   

- Advertisement -