huguogang

RIGHT('00000' + CAST(myNumber AS VARCHAR), 5) 

huguogang

<script src="http://gist.github.com/467670.js?file=gistfile1.sql"></script>

huguogang

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

huguogang

IF EXISTS (SELECT * FROM sys.assembly_modules WHERE assembly_class='ConcateAll')    
BEGIN
    DROP AGGREGATE dbo.ConcateAll
END
IF EXISTS (SELECT * FROM sys.assemblies WHERE name='SQLCLR')    
BEGIN
	DROP ASSEMBLY [SQLCLR]
END

huguogang

    CREATE ASSEMBLY [SQLCLR]
    FROM 'c:\temp\SQLCLR.dll'
    GO

huguogang

CREATE AGGREGATE dbo.ConcatAll(@input NVARCHAR(4000))
RETURNS NVARCHAR(4000)
EXTERNAL NAME SQLCLR.ConcatAll

huguogang

GRANT EXECUTE ON ConcateAll To my_user

huguogang

buttonMode = true;
useHandCursor = true;

huguogang

<cffunction name="createExcelObj" access="public" returntype="any" output="false" >
<cfset var oExcel = "">       
<CFOBJECT ACTION="CREATE" CLASS="Excel.Application" NAME="oExcel" TYPE="COM">
<cfscript>
//remove all interactions
oExcel.AlertBeforeOverwriting = false;
oExcel.AskToUpdateLinks = false;
oExcel.PromptForSummaryInfo = false;
oExcel.Visible = false;
oExcel.DisplayAlerts = false; 

huguogang

-----------------------------------------------------------------------
-- Collection of queries that helps in performance tuning

--grant permission to user
GRANT VIEW SERVER STATE TO [user_name]

------------ based on http://msdn.microsoft.com/en-us/magazine/cc135978.aspx 
---------- Uncover hidden data to optimize application performance -----------------------

-- * Number of missing indexes