php调用mssql存储过程实例应用
发布:smiling 来源: PHP粉丝网 添加日期:2014-09-12 09:30:44 浏览: 评论:0
用mssql_init语句用于初始化存储过程,而后调用mssql_bind语句指定存储过程参数,最后调用mssql_execute执行存储过程.
连接mssql数据库教程服务器,代码如下:
- $link = mssql_connect("127.0.0.1", "sa", "sa") or die("Can't connect sql server");
- mssql_select_db("frrc", $link) or die("Select database failure");
- //初始化并加载存储过程 Bigdatabase
- $stmt = mssql_init("Bigdatabase", $link) or die("initialize stored procedure failure");
- 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");
- do{
- while( $ms_rs = mssql_fetch_object($ms_result) )
- {
- //进行数据处理
- }
- }
- // msssql 存储过程 Bigdatabase如下
- //开源代码phpfensi.com
- /*
- CREATE PROCEDURE Bigdatabase
- @pagesize int,
- @start int
- AS
- declare @bsql nvarchar(4000)
- set @bsql = 'select top ' + str(@pagesize) + ' username,jobid,password,useremail,zcdata,ip,name,xingbie,minzu,xueli,hunyin,age,xuexiao,zyclass,zhuanye,x_suozaidi,x_suozaidi1,huji,huji1,shengao,byear,birthyear,birthmonth,birthday,dianhua,qq,gerenzhuye,selectedjob1,selectedjob2,selectedjob3,s_PWL1,s_PWL2,s_PWL3,daiyuyaoqiu,Negotiable,provideHouseNeeded,availOpts,availNotice,llcs,CONVERT(varchar(100),dlsj, 25) as dlsj,xgsj,dlcs,jsjshuiping,language_one,l_OneAbility,language_two,l_twoAbility,mandarinLevel,skillkey,jingyan,photopb,photo,phototre,mbsys,codetype,code,shouji,posts,address,jobtype,convert(varchar(8000),pingjia) as pingjia ,convert(varchar(8000),jinengzhuanchang) as jinengzhuanchang ,convert(varchar(8000),fazhanfangxiang) as fazhanfangxiang,convert(varchar(8000),other) as other 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
- GO
注:必须把text转换成varchar来处理,否则会出问题.
Tags: php调用mssql php调用存储过程
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)