huguogang

<cfscript>
    //list all the JDBC drivers for diagnosis purpose
    factory = createObject("java","coldfusion.server.ServiceFactory");
    writeDump(factory.dataSourceService.getDrivers());
    
    fileName = "d:/temp/temp.mdb";
    classLoader = createObject("java","java.lang.Class");
    driver = classLoader.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    //connect to MDB using 64-bit java and 64-bit MS Access Driver
    connStr = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" & fileName;

huguogang

<cfscript>
    private struct function test() {
        if(1 == 1) {
            if(1 == 0) {
                writeOutput("1==0");
            };
            writeOutput("true");
            return {data = 1};
        }
        writeOutput("false");

huguogang

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

huguogang

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

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;