亚洲免费不卡_在线视频精品_国产尤物精品_久久久久网址_久久精品91_欧美va天堂在线_狠狠入ady亚洲精品_亚洲午夜精品福利_国产精品草草_午夜精品久久99蜜桃的功能介绍

php 調(diào)用mssql 2000存儲(chǔ)過(guò)程代碼這是我昨天做出來(lái)了哦，下面我們先看看利用php調(diào)用mssql的存儲(chǔ)過(guò)程的代碼吧

$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");

現(xiàn)在來(lái)看mssql數(shù)據(jù)表存儲(chǔ)過(guò)程函數(shù)哦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

更多信息請(qǐng)查看IT技術(shù)專(zhuān)欄