JAVASCRIPT

Combining North Pole with South Pole: JavaScript with SQL Server 2000

Every DBA/database developer would certainly be shocked to think about a relationship between client-side JavaScript and SQL Server 2000. It's real. Not every programmer knows that we can connect and break into SQL Server 2000 simply by using client-side JavaScript. This article covers the positive aspects of connecting to a SQL Server 2000 database lying on the client computer (or the browser computer).

Author Info:

By: Jagadish Chaterjee

Poor Best

Rating:

/ 13

May 16, 2006

TABLE OF CONTENTS:

In the previous section, I gave you only the view names. I know that this is not very useful. Let us further extend the code and develop a simple script (JavaScript) which shows the technique for retrieving the SELECT statement of a view available in a SQL Server 2000 database. The entire code for the sample is as follows:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
      <head>
            <title></title>
            <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
            <meta name="vs_targetSchema" content="http://schemas.microsoft.com/
intellisense/ie5">
            <script id="clientEventHandlersJS" language="javascript">
<!--
functionButton1_onclick() {
      var locator = new ActiveXObject ("WbemScripting.SWbemLocator");
      var service = locator.ConnectServer(".","rootMicrosoftSQLServer");
      var properties = service.ExecQuery("SELECT * FROM MSSQL_View where name='[dbo].[Invoices]'");
      var e = new Enumerator (properties);
      var p = e.item ();
      document.write(p.Text);

}

//-->
            </script>
      </head>
      <body>
            <INPUT id="Button1" type="button" value="Button" name="Button1"
language="javascript" onclick="return Button1_onclick()">
      </body>
</html>