Hi Farrukh,
You can use an empty parameter map.
<parameterMap id="EmptyParam"></parameterMap>
<procedure id="GetAllOrders" parameterMap="EmptyParam"
resultMap="myResultMap">
GetBusinessCustomFields
</procedure>
Cheers,
Peter
Farrukh Nizami wrote:
Hi,
I have a simple stored procedure that returns all the rows
from a table.
CREATE PROCEDURE [dbo].[GetAllOrders]
AS
SELECT [OrderID]
,[CustomerID]
,[EmployeeID]
,[OrderDate]
,[RequiredDate]
,[ShippedDate]
,[ShipVia]
,CAST([Freight] AS Real) AS Freight
,[ShipName]
,[ShipAddress]
,[ShipCity]
,[ShipRegion]
,[ShipPostalCode]
,[ShipCountry]
FROM [Northwind].[dbo].[Orders]
How to call this stored procedure? Whenever I want to call this SP, it
complains that it need parameterMap attribute in procedure tag. But I
do not need any parameter to call this SP. Please help
*/Thanks & Regards
/**/Farrukh Nizami/*
*Axentis Software Private Limited
Unit # 3, Ground Floor, Inventor Block,
I T P B, **Whitefield Road,
Bangalore: 560066, I N D I A*
*P: 91-80-28416690 / 91 / 92 / 93 Ext. 2050
F: 91-80-28412010
M: 0-98867-32213*
*Web:* www.axentis.com
<file:///C:/Documents%20and%20Settings/fnizami/Application%20Data/Microsoft/Signatures/www.axentis.com>
