alter PROC [DBO].[Proc_GetActiveDistrictWise]
@District varchar(30)
AS
BEGIN
DECLARE @VAR VARCHAR(500)
SET @VAR= 'SELECT COLLEGENAME'+','+'LOCATION FROM COLLEGEDETAILS WHERE DISTRICT= '+@District
EXEC(@VAR)
END
'chennai'
is removed from the procedure.
alter proc dbo.Proc_GetActiveDistrictWise
is the very first statement of procedure and that contains the name of it, So you just cannot pass parameter over there.
What you can do is, in Solution Explorer right click on Procedure >> Execute >> It will come up with the dialog having number of parameters that you've defined within procedure. Over there you can pass whatever value you want.
Give it a try.!
Good Luck.