| 标题 | php 调用mssql 2000存储过程代码 |
| 范文 | php 调用mssql 2000存储过程代码这是我昨天做出来了哦，下面我们先看看利用php调用mssql的存储过程的代码吧 $start = isset($_GET['start'])?$_GET['start']:0; $end = isset($_GET['end'])?$_GET['end']:0; $pagesize = isset($_GET['pagesize'])?$_GET['pagesize']:0; $stmt = mssql_init("Bigdatabase", $link) or die(""); mssql_bind($stmt, "@pagesize", $pagesize, SQLINT4); mssql_bind($stmt, "@start", $start, SQLINT4); @$ms_result = mssql_execute($stmt, false); mssql_query("DUMP TRANSACTION tempdb WITH NO_LOG"); 现在来看mssql数据表存储过程函数哦Bigdatabase CREATE PROCEDURE Bigdatabase @pagesize int, @start int AS declare @bsql nvarchar(4000) set @bsql = 'select top ' + str(@pagesize) + ' username,from person where id not in(select top ' + str(@start) + ' id from person order by id asc) order by id asc' execute sp_executesql @bsql |
| 随便看 |
|
在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。