Welcome Guest, Not a member yet? Register   Sign In
get output from Stored Procedure
#1

Hello How are you
I want to get a value as output from Stored Procedure in Microsoft SQL Server but I can't

my Stored Procedure code:

Code:
ALTER PROCEDURE [dbo].[count_message]
        @username smallint
    
    
AS    SET NOCOUNT ON;

     
 

return  isnull((select count(*) from dbo.sd_message where ms_user=1 or [email protected]),0)


my PHP/Codeingiter Code:

PHP Code:
$result $this->db->query("update_message '2300'");
echo 
'resutl:'.$result
Reply




Theme © iAndrew 2016 - Forum software by © MyBB