how can i execute Stored procedures having coalesce functions

See more:

SQL-Server-2005

SQL-Server

hai i am new .net developer. what my problem i wrote a stored procedure for getting data from some table my procedure i like this

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