what is Procedure? creating procedure

Posted by Fundaravi under Sql Server on 4/13/2012 | Points: 10 | Views : 1964 | Status : [Member] | Replies : 10

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Id Name Marks
101 Ravi 50
102 Raju 95

Create a stored procedure for above code and if u give id as input have to display the corresponding values like Name and Marks.so if you give null as id have to display all the values in the table?

Ravindra

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	hi, Create Procedure procedurename(@action char(1),@id int,@name varchar(25), @marks int) as begin if(@action=s) Select * from table name end Thanks & Regards Hari Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	create procedure mysp(@id int) as if(@id='') begin select * from tablename end else begin select name,marks from tablename where id=@id end exec mysp @id='' you will get all records exec mysp @id=1 u will get the records basing on id k.m.j.kiran Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	hi fundaravi, try the above code i think it will be helpful to u if it is useful plz mark it as answer k.m.j.kiran Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sabarimahesh on: 4/16/2012 [Member] Bronze | Points: 25

0	Hi .. if u Want Video Reference http://www.youtube.com/watch?v=VfDbaW17JRo Life is a Race Thanks & Regards By Sabari Mahesh P M Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sabarimahesh on: 4/16/2012 [Member] Bronze | Points: 25

0	Create Procedure Sp_procedurename @id int As begin Select * from Table_name where id=@id end Life is a Race Thanks & Regards By Sabari Mahesh P M Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	HI, CREATE PROCEDURE STUDETMARK @STUDENTID INT AS SELECT * FROM STUDETMARKS WERE STUDENTID=@STUDENTID GO HOPE THIS WILL HELP REGARDS SRIRAM.R sriram Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sabarimahesh on: 5/21/2012 [Member] Bronze | Points: 25

0	Fundaravi hi Have You Got The answer Life is a Race Thanks & Regards By Sabari Mahesh P M Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/19/2012 [Member] Bronze | Points: 25

0	Refer this link http://msdn.microsoft.com/en-us/library/aa258259(v=sql.80).aspx Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Muhsinathk on: 6/19/2012 [Member] Bronze | Points: 25

0	Refer this link too. http://msdn.microsoft.com/en-us/library/ms187926.aspx Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Hariinakoti on: 6/19/2012 [Member] Starter | Points: 25

0	Hi Ravi, If u got the answer plz mark that one.. Thanks & Regards Hari Fundaravi, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts