SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE SP_GetSubscriptionDetails (@State_ID NVARCHAR(5) ,@Disrict_ID NVARCHAR(5) ,@Name NVARCHAR(50) ,@Status NVARCHAR(1)) AS BEGIN SELECT * FROM tablename WHERE cname LIKE COALESCE(cname,'') AND Disrict_ID LIKE COALESCE(@Disrict_ID,'%%') END but i dont know how i can i run this stored procedure can any one plz help me
EXECUTE SP_GetSubscriptionDetails 'State', 'District', 'Name', 'Status'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)