andyle0302/SQLCode

tips & tricks

SQLCode

Function

• FunctionConvertDateCrossApply: Convert VARCHAR Date type DD/MM/YYYY and return to YYYY-MM-DD
• FunctionReturnDateInMonth: Return number of date in month. Input VARCHAR Date type YYYYMMDD
• FunctionReturnTable: Example function about how to return a table by SQL query command.
• FunctionReturnTableSegment: Function create segmentation for customer base on income.
• FunctionReturnVariable: Example function about returning a variable.
• FunctionReturnWeek: Return week in year.

Procedure

• ProcedureImportCSVFile: Procedure to import CSV.
• ProcedureImportTextFile: Procedure to import txt file.
• ProcedureSelectWorkOrder: Procedure of SELECT query.
• ExecRcodeFromSQL: Run R code inside SQL.

Useful Example

• ImportFromOpenRowSet: How to use OPENROWSET command to load excel file into data base.
• Index: How to create index for table
• backup: Backup database.
• AttachDatabase: Attach database.
• Pivotable: How to create a pivotable in SQL.
• PartitionTable: Partition table according time in SQL.
• SwitchOutDataByPartition: Switch out data by partition group.
• Inline&MultipleStatementFunction: Example about Multi-Statement Function.