C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » SQL Server »

Stored Procedure


Posted Date: 21 Oct 2008      Posted By: Vasundhara      Member Level: Gold     Points: 1   Responses: 2



Hi,

Can anyone give me the stored procedure for the following scenario

Create a stored procedure based on the Production. Product table in the Adventure Works database that accepts a date as an input parameter and returns product data based on the input date you gave.


Thanks in advance





Responses

Author: Ashwini Rupert    21 Oct 2008Member Level: DiamondRating: 3 out of 53 out of 53 out of 5     Points: 3

Hi,

As per the data you gave

CREATE PROCEDURE Production
(
@date DATETIME
)

AS

Begin

SELECT * from product where product_date = @date

End


You have not specified the column names or the table name so i have typed my own for the same.
Kindly get back in case you are not clear.

Regards,
Ashwini



Author: Sandeep Pote    21 Oct 2008Member Level: BronzeRating: 1 out of 5     Points: 1

This forum is for asking the questions or for the stuff which you are trying but not reaching upto the rfirst and esults. Please try the stored procedure if you any queries then post into the forum, dont ask your task to the entire forum.


Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : Query
Previous : about database
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use