store procedure with join

Question

Hi I want create Store procedure with join

Anuja Pawar · Answer

joins are used to query data from two or more tables based on a relationship between certain columns in these tables. Types of JOIN you can use JOIN : Return rows when there is at least one match in both tables LEFT JOIN : Return all rows from the left table even if there are no matches in the right table RIGHT JOIN : Return all rows from the right table even if there are no matches in the left table FULL JOIN : Return rows when there is a match in one of the tables For more detail about joins refer this http://www.gplivna.eu/papers/sql_join_types.htm I hope after reading this you can create a stored procedure using join

Vineet Kumar Saini · Answer

It's simple the selectable stored procedure works as any table. select t1.id sp1.field1 from t1 join sp1(parameters) on t1.id = sp1.id; It you wish you can also use fields from the table as input values into stored procedure. It that case make sure you use LEFT JOIN to force table fields to be evaluated first (so they are available to stored procedure): select t1.id sp1.field1 from t1 left join sp1(t1.id) on 1=1; Thanks.....

Prabhu Raja · Answer

Hi You can get Sample Code from : http://searchsqlserver.techtarget.com/feature/Sample-T-SQL-stored-procedure-P_DisplayProductDetails