php调用MSSQL存储过程的方法

创建一个MSSQL存储过程：

CREATE PROCEDURE dbo.P__Test_GetData(
	@UserId int,
	@UserName nvarchar(100) output
)As
set nocount on
	
	select 
              @UserName = UserName 
        from _Test 
        where UserId = @UserId
set nocount off
GO

php中调用方法：

<?php
require 'dbconn.php';
$userId = 1; // 定义输入参数 
$userName; // 定义返回值
$stmt = mssql_init("P__Test_GetData", $conn) or die("initialize stored procedure failure");
mssql_bind($stmt, "@userid", $userId, SQLINT4);
mssql_bind($stmt, "@username", $userName, SQLVARCHAR, true);
$rs = mssql_execute($stmt, false);
echo "This user name is: ".$userName;
?>

返回结果：

This user name is: BanLao.