SQL trans in VBscript or stored procedure

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

I am not a programmer, but got asked this question when discussing SQL transaction processing:

If one is writing Web Pages (ASP) what is the best way to to capture dynamic parameters?

A. embed the SQL transaaction in the ASP (using VBscript) OR B. just have the call to the stored procedure in the ASP (using VBscript)?

-- Anonymous, October 20, 2000



This is a religious discussion. I prefer having the ASP call a stored procedure because it hides the complexity of writing SQL code. Developers I have worked with vehemently argue in favor of putting the SQL code in the ASP so that at some time in the future it would not be difficult to change to a different DBMS.

It's your call.

(Sorry for the delay in answering. I was on vacation.)

Hope this helps,


-- Anonymous, November 04, 2000

Moderation questions? read the FAQ