I HAVE A PAREMENTER IN SQL
CREATE PROCEDURE EMPSP
(@EMPID LARGENUMBER)
AS
BEGIN
SELECT * FROM EMP WHERE EMPID=@EMPID
END
WHEN I PASS THE @EMPID =1 THEN EXUTE THE SP OR WHEN I PASS THE 344 THEN EXCUTE THE SP HOW TO CHECK THE PARAMANTER VALUE IN WHERE CLUSE
Go to the complete details ...