创建一个MSSQL存储过程:
CREATE PROCEDURE dbo.P__Test_GetData(@UserId int,@UserName nvarchar(100) output)Asset nocount onselect @UserName = UserName from _Test where UserId = @UserIdset nocount offGO
php中调用方法:
返回结果:
This user name is: BanLao.