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.