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.