CREATE PROCEDURE spCattotal Sex Char(1),Weight Varchar(50) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
select * from Cat where Sex=@Sex and Weight=@Weight END GO Above store procedure i have passed two parameters normally i have implemented using one parameter. my problem is as follows <sql-query name="spCat"> <return alias="spCat" class="Cat"> <return-property column="CatId" name="Id" /> <return-property column="Sex" name="Sex" /> <return-property column="Weight" name="Weight" /> </return> exec dbo.spCat :Sex,Weight (here is problem how to pass two parameters here) </sql-query>
|