How to get a scalar value output by Executing a SQL Server's Stored
Procdure from Javascript(JS) file.
Although there are some examples on internet with Server object i.e
Server.CreateObject("ADODB.connection")
but i m seeing the error "Server is undefined".
If i put this code on a web page (e.g aspx - asp.net 2.0 ) then it will work
fine. But my requirement is to Execute this code from JS file.
(
JS file is called by an HTML page via a Script tag.
<script type="text/javascript" src="myFile.js"></script>
)

javascript cannot "talk" directly to a SQL server

No, it cannot for security reasons. Javascript code is client-side, which means anyone can read it...including any parts related to connection to the database.

This could be done in AJAX, but not Javascript. How you do it depends on your setup, there are about a million answers, and you're not going to get one in this thread for what you're doing.

This, however, leads to a deeper problem...you seem to be overtrained in knowledge and undertrained in application and critical thinking. You need to do some studying up on what different languages can do and how they're to be used.

Scalar = 1 value, something that can fit into a variable that isn't a collection or an array. You can get the return value to javascript using a hidden input form field.

You can build an ASPX page that the javascript calls, and have that page execute your procedure and put the results in a hidden field.

Your database server shouldn't be reachable from just any random person's computer who's looking at your page. Forget SQL Injection - that only happens when a person can guess how your application works, and give just hte right input to trick it into running a query they want run. Imagine the fun that comes when people can just send any query they like directly, using javascript. Think

DECLARE @SQL VARCHAR(MAX)
SELECT @SQL = 'TRUNCATE TABLE ' + NAME FROM SYS.TABLES
EXEC (@SQL)

Bye bye all the data in your database.

Why would you ever want to let people talk directly to your SQL Server themselves?