Alphanumeric sorting in sql server 2005

elect SectionNumber from tableName order by Left(replicate('0',20) + SectionNumber, 20)

stop running this script error asp.net a script on this page is causing ie to run slowly if it continues to run

There are situations when a Web page contains script that takes an unusually long time to run.
There will be a warning message after a certain number of statements has been processed.

The solution is to increase the default number of statements,before the warning is given


1.Go to Start/Run/type :regedit

Open this key: HKEY_CURRENT_USER\Software\Microsoft\InternetExplorer\Styles

(If the Styles key is not present, create a new key that is called Styles.)

2.Right click anywhere in the right pane and create a new DWORD value called "MaxScriptStatements"
(copy and paste that in to the name box) and set the value to the desired number of script statements.

Try 8,000,000 to start with.

CLOSE A WEB PAGE in C#

 Response.Write("<script language='javascript'> { window.close();}</script>");