当前位置:编程学习 > asp >>

ASP做查询分析器(Query Analyzer)(I)

sqlultimate.asp--Part A
<%@ LANGUAGE = VBScript %>
<%
Option Explicit
Response.Buffer = True
Session.Timeout = 1
Response.ContentType = "text/html; charset=iso-8859-1"
'--------------------------------------------------------------
'--- Declarations
'--------------------------------------------------------------
Dim strQueryType
Dim strClip          ' String to display workspace
Dim strDB          ' String to display relative database path
Dim strTable           ' String to hold the table name
Dim numTableValue
Dim strDBName
Dim strdbpath
Dim strConnect
Dim strSQL
Dim boolTableInfo
Dim strServer
Dim strUserID
Dim strPassword
Dim count
Dim intSpacer
Dim strIdentity
Dim strQuery
Dim strLoad
Dim strCreate
Dim strTableName
Dim strQOption,strQOption1,strQOption2,strQOption3
'--------------------------------------------------------------
'--- Initialization
'--------------------------------------------------------------
strTable = request("schema")
strClip = Trim(Request.Form("strClip"))
If request("selectdb") = "Select DB" Then
     strSQL = ""
Else
    strSQL = Trim(Request.Form("strSQL"))
    strSQL = replace(strSQL,vbCrLf,"")
    strClip = Trim(Request("strClip"))        ' get workspace values from form
End If
strLoad = request("Load")
If request("submitquery") = "Submit Query" Then
     strSQL = Trim(request("strSQL"))
补充:asp教程,高级应用 
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,