store procedure execution

Posted by Sahoo under Sql Server on 4/16/2012 | Points: 10 | Views : 1460 | Status : [Member] | Replies : 7
Hi,
please help me to execute this stored procedure manually-

CREATE Procedure [dbo].[MY_Menu]
(
@CatRef varchar(100)
, @MenuCode varchar(8000) out
, @AreasID varchar(200)
, @ProjectId int
, @LanguageId int
)


Thanks a lot in advance




Responses

Posted by: Hariinakoti on: 4/16/2012 [Member] Starter | Points: 25

Up
0
Down
Plz tell me ur doubt clearly


Thanks & Regards
Hari

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kk86kiran on: 4/16/2012 [Member] Starter | Points: 25

Up
0
Down
hey in this u have only declarations of variables only u dont have any statements in this with statement we didnt get any output

k.m.j.kiran

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sahoo on: 4/17/2012 [Member] Starter | Points: 25

Up
0
Down
I want to know how to call this stored procedure explicitly.

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kk86kiran on: 4/17/2012 [Member] Starter | Points: 25

Up
0
Down
This is not a stored procedure so we cant execute it.

k.m.j.kiran

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vijetha on: 4/17/2012 [Member] Starter | Points: 25

Up
0
Down
HI,

CREATE PROCEDURE TESTPROC
@PRICE DECIMAL(10,2)
AS
BEGIN
Select * from Item_Master WHERE PRICE=@PRICE
END

this is THE STATEMENT USED TO EXECUTE SO
EXECUTE TESTPROC 65.99


Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Leila on: 4/17/2012 [Member] Starter | Points: 25

Up
0
Down
CREATE Procedure [dbo].[MY_Menu]
(
@CatRef varchar(100)
, @MenuCode varchar(8000) out
, @AreasID varchar(200)
, @ProjectId int
, @LanguageId int


declare @MenuCode varchar(8000)
exec [MY_Menu] 'CatRef', @MenuCode, 'AreasIds', 1, 1
where ProjectId = 1 and LanguageId = 1


Thanks,
Leila

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/19/2012 [Member] Starter | Points: 25

Up
0
Down
Hi,

Create procedure sp_product
@productid int
@productname varchar(90),
@productPrice money
as
select * from productDetails where productid=@productid and productname=@productname and productprice=@productprice;
go

hope this will help

Regards
Sriram.R


sriram

Sahoo, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response