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