PHP 调用MSSQL存储过程

存储过程如下:

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 t_name=@TableName)
  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'];
?>

阅读更多
上一篇存储过程游标及WHILE语句
下一篇PHP 格式化日期
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭