php mssql_init,PHP mssql_init 用法 手册 | 示例代码

this function was created to support

OUTPUT parameters and return values with

MSSQL stored procedures. Before this,

you could use T-SQL statement EXECUTE

and mssql_query to execute a stored

procedure, and it was fine as long as

you don't need to retrieve OUTPUT or

RETVAL values.

Now you can use this set of functions to execute and retrieve these values:

mssql_init

mssql_bind

mssql_execute

Parameters:

- sp_name : stored procedure name. It passes this string to a native DB-lib call, so I guess it supports all kinds of schemas (like "ownew.sp_name" or "otherdb.owner.sp_name")

- connection id: a connection resource

obtained with mssql_connect or similar.

If not provided, it will proceed just

like other similar mssql_* functions:

uses a default open connection or

creates a new one.

Return value: a resource id, called

"statement", used in subsequent calls to

mssql_bind and mssql_execute.

Note that many of the native MSSQL data types are directly supported, but I

think that some others must be converted

by other means (from varchar values for

example). These unsupported types are:

SQLMONEY4,SQLMONEY,SQLBIT,SQLDATETIM4,

SQLDATETIME, SQLDECIMAL, SQLNUMERIC,

SQLVARBINARY, SQLBINARY,SQLIMAGE

More info on supported types and new constants in mssql_bind