在存储过程中:select * from tablename or viewnamereturn value
解决方案 »
- 关于一条SQL多条件的查询
- 跪求解决方案:数据库想从A机转移到B机
- 如何将注册数据库的备分文件备份到本机,
- 数据恢复问题
- 俺新手,有个题目完全没有头绪,请求指点:
- 请教insert触发器支持批量插入吗?在线等,TKS!
- 求一条SQL语句:当值x大于字段R2的最大值时,选取字段R2为最大值的那一整条记录???
- sql连接
- 请较高手,我如何在sql 2000中将两个字段设为关键字?
- 我用ADO调用SQL Server2000,老报“Microsoft OLE DB Provider for SQL Server 错误 '80040e14'”错误,请问是什么错误
- 如何用SQL server中的导入数据功能导入文本文件?(急!)
- 请问“支持50个用户的sqlserver”什么意思
as
....
select * FROM table or view
returen [inter_expression]
--------------------------------
declare @para1 varchar[20]
EXEC sp_name @para1
select @para1
SELECT * FROM titles
SELECT * FROM publishers
GOThe stored procedure generates two result sets: one for the result of SELECT * FROM titles and the other for the result of SELECT * FROM publishers.The ADO code syntax is:Dim cmd As New ADODB.Command
Dim rs As ADODB.Recordset cn.Provider = "sqloledb"
cn.Properties("Data Source") = "MyServerName"
cn.Properties("Initial Catalog") = "pubs"
cn.Properties("user ID") = "sa"
cn.Properties("password") = ""
cn.OpenCmd.CommandText = "myNextProc"
Cmd.CommandType = adCmdStoredProcSet rs = Cmd.Execute
While Not rs Is Nothing
If (Not rs.EOF) Then
Debug.Print rs(0)
End If
Set rs = rs.NextRecordset
Wend
runtime Error '3704'
对象关闭时,操作不允许!
2、源码如下:
Public Function GetProductRecord()
Dim strSQL As String
Dim flag As Boolean
Dim objCMD As New ADODB.Command
' Dim gNewageConn As New ADODB.Connection
Dim intRecordAffected As Integer
flag = True
'-----------------2002-04-22----------为修改成为可以多个WebE Job同时运行
strSQL = "exec sp_selectDealProduct"
'=======================================================================
Set adoRSTemp = New Recordset
objCMD.ActiveConnection = gNewageConn
objCMD.CommandText = "sp_selectDealProduct"
objCMD.CommandType = adCmdStoredProc
Set adoRSTemp = objCMD.Execute
'strSQL = "SELECT TOP 1 * FROM PRO_REGPRO AS A LEFT JOIN PRO_MODELNO AS B ON B.HPM_ID=A.HPM_ID WHERE PRG_ID=99435"
'adoRSTemp.Open strSQL, gNewageConn, adOpenStatic, adLockOptimistic
' Set adoRSTemp = gNewageConn.Execute(strSQL, intRecordAffected)
If adoRSTemp.EOF Then flag = False
GetProductRecord = flag
End Function