2020-02-16 标签:asp,递归,调用,已知,节点,查找,函数,实现,代码,如下,function,pnodeid,getsql,select,n,ote,id,parent

实现代码如下：Function getTreeRootId(pNodeId) getSQL = "select note_id,parent_id from [T_tree_demo] where note_id='"& pNodeId &"'" Set getRs = db.Exe

2020-02-16 标签:php,mssql,分页,sql,语句,优化,持续,影响,实现,代码,如下,filename,page,class,creattime,2009,01,06,descrition,此类

实现代码如下：getsql(); 优化后的语句： SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 270 Lsh,Ztm,Dyzrsm,Dyzzfs,Cbsm,Cbny,Ssh,Fbsl,jcsl from ts_gcb where Ssh like

2020-02-16 标签:asp,n,et,执行,事务,代码,数据库,sqlconn,ull,sqltrans,try,操作,system

//数据库执行区, SqlConnection _sqlConn = null; SqlTransaction _SqlTrans = null; try { //数据库操作类 _sqlConn = System.mySQLConnection.SqlConnections.GetSQLConnec

2020-02-16 标签:php,sprintf,函数,让你,sql,操作,安全,booksql,update,book,set,pass,s,id,d,post,list,text,int

$bookSQL=sprintf("UPDATE book SET pass=%s WHERE id=%d",GetSQLValueString($_POST['list'], "text"),GetSQLValueString($_GET['id'],"int")); GetSQLValueStr

2020-02-16 标签:sql,事务,应用,积累,实现,代码,如下,summary,批量,执行,语句,param,n,ame,sqlstr,数组,参数,对象,returns,public

实现代码如下：/// /// 批量执行SQL语句 /// /// SQL语句数组 /// SQL参数对象数组 /// public static Int32 ExecuteSqls(String[] Sqlstr, List param) { String ConnStr = GetSqlCo

2020-02-16 标签:getsqlinfo,vbs,获得,sql,数据,日志,空间,使用情况,脚本,使用,已使,用的,script,data,log,space,used,unused,free

获得SQL数据/日志空间使用，已使用的和未使用的空间的脚本 getSQLinfo.vbs 'script to getSQL DATA/LOG Space Used, Space unused,and Space Free'Author: Felipe Ferreira, Daniel Magrin