Creating a stored procedure in SQL
Home > IT Answers > Development > Creating a stored procedure in SQL
SQL Server Ask the Experts
2445 pts.
0
Q:
Creating a stored procedure in SQL
SQL, Stored Procedures, Parameters
I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?
ASKED: Oct 13 2008  6:50 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
This can be done using dynamic SQL.

CREATE PROCEDURE YourProcedure
       @WhereColoum sysname,
       @WhereValue varchar(20)
 AS
 DECLARE @SQL nvarchar(4000)
 SET @SQL = 'SELECT *
 FROM YourTable
 WHERE ' + @WhereColoum + ' = ''' + @WhereValue + ''''
 exec (@SQL)
Last Answered: Oct 14 2008  5:35 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0