Hi Dan, I've used the XML feature in SQL Server, known as SQLXML.
More info here http://www.sqlxml.org/ It's pretty interesting stuff, but there are some issues. Witango is limited to using the SQL ODBC Client, and SQLXML has a built in limitation that it will only return something like 1024 bytes of XML wrapped data - meaning the XML results are often truncated (and broken). To get around this, you have use the SQLOLEDB or the native SQL interface, which Witango might be able to access via COM (never tried it myself). And there is also an IIS add-on that allows direct SQLXML template files (in XML format of course) or OPENXML - which introduces Security considerations of course. There is also a set of .NET Classes that interact with SQLXML. But in order to do any of this stuff (over and above the ODBC version) you have to get the full SQLXML install. The full SQLXML is free but comes with some required licensing provisions. I've deployed a solution using the SQLXML .NET Classes and it's pretty cool, if I say so myself :-) But I'm going to avoid SQLXML development in the future because of the licensing issues, which made deployment a nightmare. It's cool technology, especially when you need the fastest XML output from your data - but I would recommend better spending your time elsewhere, at least until they change the licensing model for it. To see SQLXML in action, open Query Analyzer (any Database) and do the following: SELECT uid, [name] FROM sysusers FOR XML AUTO Cool, eh :-) Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community --------------------- XML-Extranet - http://xmlx.ca 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) --------------------- > -----Original Message----- > From: Dan Stein [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 11, 2003 6:29 AM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: SQL Learning recommendations > > Thanks. I also wonder about the general question. How often > do people use stored procedures with SQL 2000 given that the > use Witango? > > How useful is it to learn the use of XML with SQL 2000 given > the use of witango? > > Dan > > on 12/11/03 8:18, Jon Pevzner at [EMAIL PROTECTED] wrote: > > > Dan, > > > > I have the Guru's Guide to Transact-SQL and it can be cryptic at > > times, but nonetheless a good reference book. Professional > SQL Server > > 2000 Programming by Robert Vieira is also an excellent book... Good > > info, covers many areas with relative simplicity and pretty easy to > > read. This guy knows his stuff. > > > > Jon > > > > -----Original Message----- > > From: Dan Stein [mailto:[EMAIL PROTECTED] > > Sent: Thursday, December 11, 2003 8:09 AM > > To: [EMAIL PROTECTED] > > Subject: Witango-Talk: SQL Learning recommendations > > > > > > List, > > > > I am looking to learn more about MS SQL. Since I use Witango for > > almost all my work with the MS SQL is it worth learning more about > > stored procedures and XML and HTML and/or extending my knowledge of > > transact SQL. > > > > There are two new books by Ken Anderson that look good but I am not > > sure if they are worth getting > > > > > > The Guru's Guide to SQL Server Stored Procedures, XML, and > HTML (With > > CD-ROM) by Ken Henderson > > Usually ships in 24 hours > > Date Added: December 7, 20 > > > > > > > > The Guru's Guide to Transact-SQL by Ken Henderson Usually > ships in 24 > > hours Date Added: December 7, 2003 > > -- > Dan Stein > Digital Software Solutions > 799 Evergreen Circle > Telford PA 18969 > Land: 215-799-0192 > Mobile: 610-256-2843 > Fax 413-410-9682 > FMP, WiTango, EDI,SQL 2000 > [EMAIL PROTECTED] > www.dss-db.com > > > "When you are born, you cry and those who love you > rejoice. And if you > live your life as you should, when you die, you rejoice and those who > love you cry." > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
