Hi what is stored procedure ..give me examples ..how to pass parameter values in stored procedure and how to return the output in stored procedure.difference b/w stored procedure and functions with examplesN.suresh

Hi Suresh, A stored procedure in SQL Server is a group of one or more Transact-SQL statements or a reference to a Microsoft .NET Framework common runtime language (CLR) method. Please click on the following link; - http://msdn.microsoft.com/en-us/library/ms190782.aspx If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com/ http://uk.linkedin.com/in/kieranpatrickwood

Hi Suresh, Recently saw a lot of your posts asking very basic questions on various topics. There are many resources (blogs, whitepapers, tutorials, videos) available on Web on these topics. You can easily find answers in details to these question by Googling. MSDN forums are meant for resloving issues by taking expert opinions from other users and sharing specific knowledge from across the world. Hence please refrain from cluttering the forum. You are most welcome for any specific query that you can not find an answer for.HTH, Cheers!! Ashish Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.

SSIS forum is not right place to ask question about stored procedures, in t-sql forum you will find lots of threads about stored procedure: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads http://www.rad.pasfu.com