PHP执行SQL存储过程遇到错误,急!急!急!
$query = "exec Page_select
({@Sqltext = \"$Sqltext\"},
{@Sqltable = \"$Sqltable\"},
{@Sqlif = \"$Sqlif\"},
{@Sqlid = \"$Sqlid\"},
{@Sqlorder = \"$Sqlorder\"},
{@Page = \"$Page\"},
{@PageSize = \"$PageSize\"})";
$result = mssql_query($query) or die("无法执行SQL:$query");
运行文件错误提示:
Warning: mssql_query() [function.mssql-query]: message: 第 2 行: '{' 附近有语法错误。 (severity 15) in D:\AppServ\www\booyi\service\Mtlogo.php on line 156
Warning: mssql_query() [function.mssql-query]: Query failed in D:\AppServ\www\booyi\service\Mtlogo.php on line 156
无法执行SQL:exec Page_select ({@Sqltext = "*"}, {@Sqltable = "[VSms_MTInfo]"}, {@Sqlif = "where 1=1 "}, {@Sqlid = "MTID"}, {@Sqlorder = "Order By MTID Desc"}, {@Page = ""}, {@PageSize = ""})