asc staffing

(FLNM) Lngsize = Objftemp.size Set objftemp = Nothing fsoforreading = 1 Set objTextStream = objFSO.OpenTextFile (flnm, fsoforreading) If offset > 0 Then Strbuff = Objtextstream.read (offset-1) End If If bytes =-1 Then ' Get all! GetBytes = Objtextstream.read (lngsize) ' ReadAll Else GetBytes = Objtextstream.read (bytes) End If Objtextstream.close Set objTextStream = Nothing Set objFSO = Nothing End Function '::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: '::: ::: ':: Funct

: idx_1 (state,time)The deadlock log appears as follows: (1) TRANSACTION: TRANSACTION 0 677833455, ACTIVE 0 sec, Process no 11393, OS thread ID 278546 starting index read MySQL tables in use 1, locked 1 Lock WAIT 3 lock struct (s), Heap size 320 MySQL thread ID, query ID 162348740 dcnet03 dcnet searching rows for update Update tab_test set state =1064, time = Now() The Where state=1061 and Time date_sub(now (), INTERVAL-minute) (SQL st

("@ PageSize", SqlDbType. Int, 4 ), New SqlParameter ("@ CurrentPage", SqlDbType. Int, 4 ), New SqlParameter ("@ SelectFields", SqlDbType. NVarChar, 700 ), New SqlParameter ("@ IdField", SqlDbType. NVarChar, 50 ), New SqlParameter ("@ OrderField", SqlDbType. NVarChar, 200 ), New SqlParameter ("@ OrderType", SqlDbType. NVarChar, 2 ), New SqlParameter ("@ TableName", SqlDbType. NVarChar, 300 ), New SqlParameter ("@ strWhere", SqlDbType. NVarChar, 300 ), }; Parameters [0]. Direction = ParameterDir

BCD and ASCII conversion and BCD to int function, re-write, it feels good. You can change the return value as needed. /*********************** Stdfunc. h ***********************/ # Ifndef _ std_func_h _# DEFINE _ std_func_h _ /*ParametersBCD: converted BCD resultASC: the ASC string to be convertedLen: length to be convertedFMT: converted format, that is, if the length is an odd number, add the value before or after zero.Return ValueLength of BCD bytes

Function urlencode (S as string) as stringIf Len (S) = 0 Then exit function Dim TMP as stringDim C as stringDim I as integer For I = 1 to Len (s)C = mid (S, I, 1)If (ASC (c)> = 65 and ASC (c) Or (ASC (c)> = 97 and ASC (c) Or (ASC (c)> = 48 and

A sort of SQL Reverse By Status field If the Status=1 time field is a positive order, if the status=0 time field is reversed Here are the results that need to come out ID Status Time 5 1 50 6 1 51 1 0 99 10 0 1 Reply to discussion (solution) SELECT * FROM (SELECT * from table where status = 1 order by time) aunion Allselect * FROM (SELECT * from table where status = O or Der by time Desc) b SELECT * FROM table order by Status Desc,if (Status=1, ' time

SQL Server database paging query has been a short board of SQL Server, idle, come up with several methods, assuming that there are table article, Field ID, year ... (other omitted), Data 53,210 (customer real data, quantity is not large), paging query each page 30, query page 1500th (ie 第45001-45030条 data), field ID clustered index, Year no index, SQL Server version: 2008R2 The first scenario, the simplest, the common method: Copy code code as follows: Select Top * from ARTICLE WHERE ID. (sel

("@OrderField", sqldbtype.nvarchar,200), New SqlParameter ("@OrderType", sqldbtype.nvarchar,2), New SqlParameter ("@TableName", sqldbtype.nvarchar,300), New SqlParameter ("@strWhere", sqldbtype.nvarchar,300), }; Parameters[0]. Direction = ParameterDirection.Output; PARAMETERS[1]. Direction = ParameterDirection.Output; PARAMETERS[2]. Value = pageSize; PARAMETERS[3]. Value = CurrentPage; PARAMETERS[4]. Value = "A.rlid,a.companyname,a.website,a.isrl,a.ordernum,a.isrl,a.userid"; PARAMETERS[5]. Valu

unnecessary context switching can be balanced with innodb_sync_spin_loops.The following section shows the deadlock condition:1.------------------------2.LATEST detected DEADLOCK3.------------------------4.060717 4:16:485.*** (1) TRANSACTION:6.TRANSACTION 0 42313619, ACTIVE sec, Process no 10099, OS thread ID 3771312 starting index read7.mysql tables in use 1, locked 18.LOCK WAIT 3 LOCK struct (s), Heap size 3209.MySQL thread ID 30898, query id 100626 localhost root Updating10.update iz set pad=

SQL Server database paging query has always been a short board of SQL Server, so I have nothing to worry about. I have come up with several methods, for example, table ARTICLE, field ID, YEAR... (others omitted). There are 53210 million pieces of data (the customer's actual data is not big), 30 pieces of data are queried by PAGE, 1,500th pages are queried (that is, the 45001-20.30 pieces of data), and the field ID is clustered index, YEAR: No index. Sqlserver version: 2008R2The first solution, t

The first solution, the simplest and common method: Copy codeThe Code is as follows:Select top 30 * from article where id not in (select top 45000 id from article order by year desc, id desc) order by year desc, ID DESC Average query time: 45 s Solution 2: Copy codeThe Code is as follows:SELECT * FROM (select top 30 * FROM (select top 45030 * from article order by year desc, id desc) f order by f. year asc, f. id desc) s order by s. year desc, s. ID D

The first solution, the simplest and common method: Copy codeThe Code is as follows: select top 30 * from article where id not in (select top 45000 id from article order by year desc, id desc) order by year desc, ID DESC Average query time: 45 s Solution 2: Copy codeThe Code is as follows: SELECT * FROM (select top 30 * FROM (select top 45030 * from article order by year desc, id desc) f order by f. year asc, f. id desc) s order by s. year desc, s.

OPTION EXPLICIT Const BASE_64_MAP_INIT = "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789+/" Dim nl ' Zero based arrays Dim Base64encmap (63) Dim Base64decmap (127) ' must be called before using anything else Public SUB Initcodecs () ' Init VARs NL = "' Setup Base 64 Dim max, IDX max = Len (base_64_map_init) For idx = 0 to Max-1 ' One based string Base64encmap (IDX) = Mid (Base_64_map_init, IDX + 1, 1) Next For idx = 0 to Max-1 Base64decmap (