SQLCode
Function
- FunctionConvertDateCrossApply: Convert VARCHAR Date type
DD/MM/YYYY
and return toYYYY-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.