I have table in this records are 1 to 20 i want to perform searching with for example id , name , city , salary
i please tell me how to create stored procedure of that
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Amit Kumar SinghPosted Feb 12, 2016, 5:07 AM
(
@ID INT,
@NAME VARCHAR(50),
@GENDER VARCHAR(50),
@SALARY VARCHAR(50),
@COUNTRY VARCHAR(50)
)
Insert Value into Table
Then Execute Procedure
Alter PROCEDURE Employee_proc
(
@ID INT,
@NAME VARCHAR(50),
@GENDER VARCHAR(50),
@SALARY VARCHAR(50),
@COUNTRY VARCHAR(50),
@Opt varchar(2)
)
AS
BEGIN
IF(@Opt='S')
BEGIN
SELECT NAME from Employee WHERE NAME like @NAME + '%'
END
END
Employee_proc 0,'A','','','','S'
Shubham KumarPosted Feb 12, 2016, 1:14 AM
@Id VARCHAR(50),
@Name VARCHAR(50)
AS
BEGIN
DECLARE @SqlQuery varchar(max), @Condition VARCHAR(max);
IF(@Id<>'')
BEGIN
SET @Condition='id='+@id;
END
ELSE IF(@Id<>'' AND @Name<>'')
BEGIN
SET @Condition='id='+@id +' and name='''+@name+'''';
END
SET @SqlQuery='select * from yourtable where'+ @Condition
END