Loading

Stor Proc SelecIndex GET DATA

Stor Proc SelecIndex GET DATA

shah Momin

4y842C#

ALTER PROCEDURE [dbo].[spFetchWorkerDetails]
	@WorkerID int
AS
BEGIN
	SET NOCOUNT ON;
	
	select *
	from Member
	where WorkerID =@WorkerID

END

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
If you want to return all rows if @workerId is not passed then
use this

ALTER PROCEDURE [dbo].[spFetchWorkerDetails]
@WorkerID int=0
AS
BEGIN
SET NOCOUNT ON;

select *
from Member
where WorkerID =Case when @WorkerID=0 then WorkerID else @WorkerID end

END
0