Hi Ramesh,
i think it helpful for you.
CREATE PROCEDURE DynamicWhereClause
(
@input varchar(100)
)
AS
BEGIN
DECLARE @sqlCommand varchar(1000)
SET @sqlCommand = 'SELECT * FROM Employee ' + @input
EXEC (@sqlCommand)
END
Examples
EX 1): EXEC DynamicWhereClause @input = "WHERE FirstName = 'venky' AND LastName = 'palepu' AND Country = 'India' "
EX 2):EXEC DynamicWhereClause @input = "WHERE FirstName = 'venky' "
Thanks
venkat