存储过程
存储过程如下：
CREATE PROCEDURE test
TableName char(20),
ii char(20) output,
bb char(20) output
AS
set nocount on
/*
if exists (select 1 from demo_table where )
set ii = 'yes'
else
begin
--RAISERROR('not have such a table',16,1)
set ii = 'no'
end
*/
select ii = t_id from demo_table where t_name = TableName
if ii is null
begin
set ii = 'no'
set bb = 'hello'
end
else
set bb = 'HAHAHAHAHQAH'
select ii as ii,bb as bb
GO
<?
include "conn.php";//连接数据库
/*
$query = " exec test 'demo_kh'";
$r = $db->query($query);
$result = $db->fetch_array($r);
echo $result['t_name'];
*/
$query = "declare ii varchar(20),bb varchar(20)\n";
$query .= "execute test 'demo_kh',ii output,bb output\n";
$r = $db->fetch_array($db->query($query));
echo $r['ii'].$r['bb'];
?>
