http://www.asp.net/Forums/Download/Default.aspx?tabindex=0&tabid=1
解决方案 »
- 跪求一个功能!
- 关于减少隐式装箱的理解。。??
- 用C#在webform上画直线(像Excel一样可拖动)?
- 有关checkboxlist的Enabled和disabled的问题
- 为什么我安装VS .NE的时候总是装不上?跪求高手指点一下了!
- 控件的自定義值如何取到? 在線等待...
- 标准表达式中数据类型不匹配。请帮忙解决,急
- DataList索引范围问题
- 我要的功能在asp.net的SQLdatasource中该如何设置?
- window.showModalDialog打开的窗口怎样能隐藏滚动条和最顶端的蓝色条?
- 关于虚拟目录的问题
- 访问量大时,总是出现连接池已满,这是不是ASP.net的先天不足啊????
中文会有一些问题
CREATE procedure Statistics_ResetTopPosters
AS
BEGIN
DECLARE @Usercount int
DECLARE @LoopCounter int SET NOCOUNT ON CREATE Table #Top500Users (
Rank int IDENTITY (1, 1) NOT NULL,
UserName nvarchar(50)
) -- Select into temp table
INSERT INTO #Top500Users (UserName)
SELECT TOP 500
UserName
FROM
Users
ORDER BY
TotalPosts DESC -- How many users did we select?
SELECT @Usercount = count(*) FROM #Top500Users -- Set the loop counter
SET @LoopCounter = 1 WHILE (@LoopCounter <= @Usercount)
BEGIN
-- clear the flags for top 25, 50, and 100
UPDATE Users
SET Attributes = (convert(int, Attributes) & 0xFFFFFFF3)
WHERE Username collate SQL_Latin1_General_CP1_CI_AS = (SELECT Username FROM #Top500Users WHERE Rank = @LoopCounter) -- top 25 poster
IF (@LoopCounter < 26)
UPDATE Users
SET Attributes = (Attributes ^ 4)
WHERE Username collate SQL_Latin1_General_CP1_CI_AS = (SELECT Username FROM #Top500Users WHERE Rank = @LoopCounter) -- top 50 poster
IF (@LoopCounter > 25) AND (@LoopCounter < 51)
UPDATE Users
SET Attributes = (Attributes ^ 8)
WHERE Username collate SQL_Latin1_General_CP1_CI_AS = (SELECT Username FROM #Top500Users WHERE Rank = @LoopCounter) -- top 100 poster
IF (@LoopCounter > 50) AND (@LoopCounter < 101)
BEGIN
UPDATE Users
SET Attributes = (Attributes ^ 16)
WHERE Username collate SQL_Latin1_General_CP1_CI_AS = (SELECT Username FROM #Top500Users WHERE Rank = @LoopCounter)
END
-- increment the coutner
SET @LoopCounter = @LoopCounter + 1
END
END
GO
重新build就可以了