[求助]在vb.net中编写存储过程和调用存储过程的例子，谁有，发过来一个，刚才网上没有找到

[求助]在中编写存储过程和调用存储过程的例子，谁有，发过来一个，刚才网上没有找到

CREATE PROCEDURE GetCustomerOrdersInfo

AS

SELECT CustomerID,CompanyName,ContactName FROM Customers WHERE CustomerID LIKE 'A%'

 

SELECT OrderID,OrderDate,CustomerID FROM Orders  WHERE CustomerID IN

(SELECT CustomerID FROM Customers WHERE CustomerID LIKE 'A%')

 

SELECT OrderID,ProductID,UnitPrice,Quantity,Discount FROM [Order Details] WHERE OrderID IN

(SELECT OrderID FROM Orders  WHERE CustomerID IN

(SELECT CustomerID FROM Customers WHERE CustomerID LIKE 'A%'))

 

GO

这个是我要用到的存储过程。。。。