Execute SQL Server Stored Procedure

[swtrans]

Can I use Javascript to execute a stored procedure in SQL Server?

If yes, what would the connection string look like and the command?

If no, what is the easiest way to execute a stored procedure from a HTML page?

Can I use Javascript to execute a bat file?

[A1ien51]

Why would you open yourself up to attack like that? You need to use a serverside language to do it. Pick your flavor from php, Java, .NET, ASP, ColdFusion, etc.

Eric

[phpnovice]

Can I use Javascript to execute a stored procedure in SQL Server?

Direct from JavaScript, no. But you can use Ajax, in combination with a server-side language, to achieve the same result. Ajax is related to JavaScript in much the same way as is DHTML. Try a Google search on Ajax and JavaScript.

[hdolden]

Yes you can execute an Oracle stored procedure from JAVASCRIPT. Execute the following JAVASCRIPT:

var query = ADO.CreateADOQuery();
query["ConnectionString"] = getConnectionString();
query.SQL='begin package_name.procedure_name(parameter_list); end;';
query.ExecSQL();

You can substitute any anonymous PLSQL block in the query.SQL line in the above example.

[hdolden]

Why would you open yourself up to attack like that? You need to use a serverside language to do it. Pick your flavor from php, Java, .NET, ASP, ColdFusion, etc.

Eric

There are legitimate reasons why someone might want to do this. Like writing a TestComplete script in JavaScript.

[hdolden]

There are legitimate reasons to do this like writing a TestComplete script in JavaScript