<%
  dim conn
  dim strconn
  dim rs
  dim strsql
  dim strsql2
  dim strsql3
  dim strsql4
  dim strsql5
  dim strsql6
  dim strsql7
  dim strsql8
  
  'strconn = Driver={SQL Server};Description=example;SERVER=222.222.1.2;UID=webexample;PWD=;DATABASE=webexample"
  
  
  'Format Declare & EXEC statements that will be passed
  'to the database with the output parameters
  strsql = "DECLARE " & CHR(10) & "@Id_Req " & "INT" & CHR(10)
  strsql2 ="exec " & "sp_EmpInfo" & " '" & request("txtFirstName") & "'," & "'" & request("txtLastName") & "', " & "'" & request("txtaddress") & "', " & "'" & request("txtcity") & "', "& "@Id_Req " & "OUTPUT" & chr(10)
  
  'Formats one or more sql statements that will be passed to the
  'database In this examples I use six different ways.
  strsql3 ="SELECT * FROM AllData WHERE RecordId = @Id_Req" & Chr(10)
  strsql4 ="SELECT AllData.fname, AllData.lname FROM Alldata WHERE RecordId = @Id_Req" & Chr(10)
  strsql5 ="SELECT AllData.fname FROM AllData WHERE RecordId = @Id_Req" & Chr(10)
  strsql6 ="SELECT AllData.lname FROM AllData WHERE RecordId = @Id_Req" & Chr(10)
  strsql7 ="SELECT AllData.Address FROM AllDa

[1] [2] [3] 下一页

在google里搜索更多使用NextRecordset通过一个Connection输出多个select查询

	Web www.51ec.org

上一篇信息学院： 利用FSO取得BMP，JPG，PNG，GIF文件信息

下一篇信息学院： 远程获取内容，并将内容存在本地电脑上，包括任何文件