/*****听以前的同事说asp页面上的分页太慢了（如果数据多了）， 就想了这么个笨办法。有些地方还要考虑----比如select top 22 * from cat_list where T_id not in (select T_id from #change)是否有效率问题；数据不能重复等等 不过灵活性挺好。希望各位高手再给帮忙改正；多谢chair3的帮助---这个存储过程还可以在加入几个变量，随便大家改吧：）*****/ CREATE proc page @pagenum int...[ 查看全文 ]
Public Overloads Sub Update(ByVal authorityArr As IList) log.Debug("Update a record in table TBL_M_AUTHORITY") Dim connection As OracleConnection = New OracleConnection(OraHelper.CONN_STRING_LOCAL) Dim command As OracleCommand = New OracleCommand(PLSQL_UPDATE, connection) command.CommandType = CommandType.StoredProcedure Dim txn As OracleTransaction Dim updateParm...[ 查看全文 ]
不实用，之所以写，一为领导的要求，另外也熟悉下写代码，代码多写点也没什么坏处，并且写了之后发现临时表还挺容易用的，数据量小的时候，并显不出临时表速度不行的问题． 代码如下： SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO /* Name:游戏中四人数据同时更新 Designed By :whbo Designed At :2005-10-12 Modified By : Modified At : Memo: */ ALTER PROC [PrMoney_Upd...[ 查看全文 ]
screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor='hand'; this.alt='Click here to open new window\nCTRL+Mouse wheel to zoom in/out';}" onclick="if(!this.resized) {return true;} else {window.open('/Files01/BeyondPic/2007-2/6/17693/1L+z17buLGxvg==_uHiJXrj6EXa4.jpg');}" alt="" src="http://img.jcwcn.com/attachment/portal/2007-2/6/17693/1L+z17buL...[ 查看全文 ]
