索引字段插的临时表如何保持原序

Mon, 08/16/2010 - 00:00 — kuuy


代码如下:

--创建临时表
 SET @strSQL = 'SELECT RowNum=IDENTITY(INT,1,1),ID INTO '+ @tmpTable
 SET @strSQL = @strSQL + ' FROM (SELECT TOP ' + ltrim(@CurrentPage*@PageSize) + ' ltrim(' + @keyName + 
           ') ID FROM ' + @tblName + @strWhere + @strOrder + ') T'
 SET @strSQL = @strSQL + ' CREATE UNIQUE CLUSTERED INDEX Idx_UC_RowNum ON ' + @tmpTable + '(RowNum)'
 
 IF @startKey <> '' --根据起始键值获取当前页最小值
 BEGIN

drupal study daily about menu hook(sub menu)

Tue, 08/10/2010 - 20:37 — kuuy

first we have to know something about the php function call_user_func_array()

 

for example:

Nginx "how to" - Fast and Secure Web Server[转载]

Tue, 08/10/2010 - 09:21 — kuuy

Nginx is a fast and efficient web server. It can be configured to serve out files or be a reverse proxy depending on your application. What makes this web server different from Apache, Lighttpd or thttpd is the overall efficiency of the daemon, the number of configuration options and how easy it is to setup.

Syndicate content