SQL Server and XML

31 Aug 2006 3:54 PM

Mark Ebling

Sorry, I've been stuck in a SQL Server 2000 and vb6.asp world and a bit
isolated.

My app is web based. It's 99.9% Transact-SQL creating HTML output and .1%
vb.asp.

My VP.asp does two things:

1. Calls a stored proc and does a response.write.
2. On submit it captures form field values and calls a proc with the
parameters and values.

That's it.

My question is can I replace vb.asp using native SQL Server XML? My big
question is the capture part.

Security and firewall updates keep killing my vb.asp development environment
and no support for vb6.

Best Regards
Mark

31 Aug 2006 4:53 PM

Kent Tegels

Hello Mark,

Replace no. Simplify, probably not. Assuming you are talking about Native
XML Web Services, you are fundamentally just replacing ADO with a SOAP proxy.
I'm not sure I'd call that easier in VB Scirpt.

If you mean using the XML type and other XML functionality, you might be
able to generate the HTML a more directly with XQuery, but its not exactly
going to make things easier.

Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/

31 Aug 2006 5:17 PM

Mark Ebling

Thanks Kent - I do need to do some research.

Show quote

"Kent Tegels" wrote:

> Hello Mark,
>
> Replace no. Simplify, probably not. Assuming you are talking about Native
> XML Web Services, you are fundamentally just replacing ADO with a SOAP proxy.
> I'm not sure I'd call that easier in VB Scirpt.
>
> If you mean using the XML type and other XML functionality, you might be
> able to generate the HTML a more directly with XQuery, but its not exactly
> going to make things easier.
>
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>
>
>