当前位置:编程学习 > 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 © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,