https://blog.youkuaiyun.com/benymarkzh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/benymark/article/details/6057135https://blog.youkuaiyun.com/benymark/article/details/6057135benymarkSun, 05 Dec 2010 23:41:00 +0800当一个表达到100万级记录的时候,用普通的查询效率是很底的了,除了用索引之外,还可以用存储过程来改进一下查询效率的.
大概如下:(申明:大部分代码来自网络)
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
Create PROC [dbo].[Pr_PageSplit]
/*
敬告：适用于单一主键或存在唯一值列的表或视图
ps:Sql语句为8000字节,调用时请注意传入参数]]>https://blog.youkuaiyun.com/benymark/article/details/5997203https://blog.youkuaiyun.com/benymark/article/details/5997203benymarkTue, 09 Nov 2010 12:11:00 +0800https://blog.youkuaiyun.com/benymark/article/details/5881507https://blog.youkuaiyun.com/benymark/article/details/5881507benymarkMon, 13 Sep 2010 17:45:00 +0800大家好,今天和大家分享下无刷新上传大文件文件东西,先说明只讲关键部分.
大概如下图:
 

 
一,目标
(1)有3种默认颜色风格
(2)支持大文件上传
(3)可以中途停止
(4)有进度信息提示
二,简述
   一个文件在http下发送整体格式是:
 
-----------------------------7d51f321004ec
Content-D]]>https://blog.youkuaiyun.com/benymark/article/details/5880982https://blog.youkuaiyun.com/benymark/article/details/5880982benymarkMon, 13 Sep 2010 14:48:00 +0800https://blog.youkuaiyun.com/benymark/article/details/5861266https://blog.youkuaiyun.com/benymark/article/details/5861266benymarkFri, 03 Sep 2010 13:43:00 +0800