- FunctionConvertDateCrossApply: Convert VARCHAR Date type
DD/MM/YYYYand 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.
- ProcedureImportCSVFile: Procedure to import CSV.
- ProcedureImportTextFile: Procedure to import txt file.
- ProcedureSelectWorkOrder: Procedure of SELECT query.
- ExecRcodeFromSQL: Run R code inside SQL.
- ImportFromOpenRowSet: How to use
OPENROWSETcommand 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.