Defining your own Functions in XQuery

Hi Kent -
There are third party implementations (for example, DataDirect XQuery)
that support XQuery functions on SQL Server 2005. Microsoft SQL Server
has a lot of partner software vendors.
Sincerely,
The Stylus Studio Team
http://www.stylusstudio.comHello Stylus,
SS> There are third party implementations (for example, DataDirect
SS> XQuery) that support XQuery functions on SQL Server 2005. Microsoft
SS> SQL Server has a lot of partner software vendors.
Sure, but I don't see them edu-advertising their products here, do you?
Look, I understand -- you have a good product, no problems with that. And
does it work with SQL Server 2005? Sure, at least at some level. And I think
that the works of Dr. Kay's that your hosted on your site are helpful to
the XQuery community in general. All I'm taking exception with is that your
potentially setting the exceptation that you're product "magically" enables
UDFs within SQL Server 2005 processed XQueries, or worse yet, that they are
natively supported. So people take time and effort to do that. You've help
set an faulty expecation. When those expectations get upset we're the ones
left to clean up the "damage" -- frustration over wasted time and effort.
That I don't really appreciate.
So if you would, do us a favor -- when your posting something to this group
that isn't natively supported by SQL Server 2005 -- include that in your
post. Then let the customer decide for themselves if what your offering is
really relativant to them not before they expend their time and ours on some
thing
that isn't. It doesn't seem like its asking too much, is it?
If you like somebody help you with that task, I'm more than happy to help.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Defining your own Functions in XQuery

Hi Kent,
The Stylus team is right here - but maybe just a little more detail
will help.
DataDirect XQuery supports user-defined functions, and it works with
Microsoft SQL Server. Since Stylus uses the DataDirect XQuery
implementation to connect to databases from many vendors, the
limitations of the Microsoft XQuery implementation do not affect us.
Also, there are a *lot* of things that Microsoft SQL Server does not
support in XQuery. Our tutorials, like most XQuery tutorials, show let
clauses in FLWOR expressions, even though SQL Server does not support
it. The article you comment on is about XQuery, not about the
limitations of the Microsoft implementation, and there *are*
full-featured implementations of XQuery that work efficiently with
Microsoft databases.
JonathanHello jonathan.robie@.gmail.com,

> The Stylus team is right here - but maybe just a little more detail
> will help.
Sure, they are right that 3rd party products do support such features. But
they aren't helpful if and when they give users false expectations about
what SQL Server 2005 does natively. I don't think its so much to ask them
to help the community understand when they do postings like this, where that
technology and what SQL Server supports diverge.

> DataDirect XQuery supports user-defined functions, and it works with
> Microsoft SQL Server. Since Stylus uses the DataDirect XQuery
> implementation to connect to databases from many vendors, the
> limitations of the Microsoft XQuery implementation do not affect us.
Frankly, I'm glad a product like yours is on the market and I've long apprec
iated
the fact that Data Direct has refrained from this kind of "edu-adversting"
in this particular newsgroup so as to not muddy the waters. Well, until now,
but hey, I guess I encouraged you to say something at least. :)

> Also, there are a *lot* of things that Microsoft SQL Server does not
> support in XQuery. Our tutorials, like most XQuery tutorials, show let
> clauses in FLWOR expressions, even though SQL Server does not support
> it. The article you comment on is about XQuery, not about the
> limitations of the Microsoft implementation, and there *are*
> full-featured implementations of XQuery that work efficiently with
> Microsoft databases.
*Lot* sometimes feels like an understatement. And again, I don't have a prob
lem
with tutorials that XQuery specific. But what I do take exception to is simp
ly
dumping thinly veiled ads in this group, getting folks excited about somethi
ng
and then not being around to clean up the mess when that goes splat. Believi
ng
that an ounce of prevention is worth more than a ton of cure, is it really
asking too much for the Stylus Studio folks to help see good expecations
at the outset?
I'd hope not.
Thanks!
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/