在vb里可以这样调用(需要引用ADO): Dim cn As New ADODB.Connection , rs As New ADODB.Recordset cn.CursorLocation = adUseClient cn.Open "Provider=MSDataShape;Data Provider=SQLOLEDB.1;Password=;Persist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=ljx" Dim cmd As New ADODB.Command cmd.ActiveConnection = cn cmd.CommandText = "存储过程名 null,null" Set rs = cmd.Execute
---------------------------------------
在查询分析器里这样写:存储过程名 null,null
cn.CursorLocation = adUseClient
cn.Open "Provider=MSDataShape;Data Provider=SQLOLEDB.1;Password=;Persist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=ljx" Dim cmd As New ADODB.Command
cmd.ActiveConnection = cn
cmd.CommandText = "存储过程名 null,null"
Set rs = cmd.Execute