this is my stored procedure plz any one help me to slove using mysql/mssql
ALTER PROCEDURE [dbo].[Emp]
-- Add the parameters for the stored procedure here
@empcode varchar(250)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
declare @qry varchar(50);
--set @emp_id=1;
SET NOCOUNT ON;
-- Insert statements for procedure here
set @qry=(
SELECT empcode from acerp_employee_details
where empcode=@empcode);
return @qry
--execute Emp
END
this is my search part
$empcode='AI000064';
$query = Yii::$app->db->createCommand("CALL Emp(:empcode)")
->bindValue(':empcode' , $empcode)