Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ER Diagram

Author  Topic 

saahil_k
Starting Member

18 Posts

Posted - 2008-02-20 : 01:57:41
Hello
I designed the ER diagram of some compony like blockbuster with some tables and i inserted 5 values in it.Now after creating the tables and inserting values i want to write a stored procedure to get members information,list all members with their age,member type name.So please help me writing the stored procedure.
Thanks

pravin14u
Posting Yak Master

246 Posts

Posted - 2008-02-20 : 02:03:51
Please refer Books online and it should guide you. Please post only if you are stuck up on issues and dont expect forum folks to write down the entire code for you.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2008-02-20 : 11:59:40
CREATE PROC <sprocname>
AS
SELECT Col FROM Table
GO


Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -