This project is read-only.

Help by feature type

Note: Objects in Bold font are available in the latest release, help pages are available for objects highlighted in blue, click to follow the link to the page.

String
  • tsql.fn_lpad - Oracle like function, pads the string to the left with given char;
  • tsql.fn_rpad - Oracle like function,pads string to the right with given char;
  • tsql.fn_occurs - xBase like function, counts substring occurences in a string;
  • tsql.fn_proper - MsExcel like function, makes forst letter of each word Capital;
  • tsql.fn_smart_replace - Custom function, allows replacing char repetions between min and max no;
  • tsql.fn_scrub - Custom function, removes unwanted chars from a given string;
  • tsql.fn_min_val - Custom function, returns the min value from a delimited list of values;
  • tsql.fn_max_val - Custom function, returns the max value from a sepparated list;
  • tsql.fn_first_val - Custom function, returns the first value in a sepparated list;
  • tsql.fn_last_val - Custom function, returns the last value in a sepparated list;
  • tsql.fn_nth_val - Custom function, returns the nth value in a sepparated list;
  • tsql.fn_mode_val - Custom function, returns the mode (most common) value in a sepparated list;
  • tsql.fn_count_val - Custom function, returns the count of values in a sepparated list;
  • tsql.fn_seek_val - Custom function, find given value and returns the position in a sepparated list;
  • tsql.fn_distinct_val - Custom function, returns only the distinct values from a sepparated list;
  • tsql.fn_list_sort - Custom function, sort a list of delimited values ASC/DESC;
  • tsql.fn_list_reverse - Custom function, reverse the elements of a list of delimited values;
  • tsql.fn_list_insert - Custom function, inserts a new value in the list at specified position;
  • tsql.fn_list_update - Custom function, updates a given item in the list;
  • tsql.fn_list_delete - Custom function, deletes an item in the list of delimited values;
  • tsql.fn_format - MsExcel/Access like function, formats string using common formats;
  • tsql.sp_join - VB like function, merges records into a delimited string;
  • tsql.fn_word_count - Custom function, counts the number of words in a string;
  • clr.fn_regex_ismatch - Custom regex function, gets the result of a substring match;
  • clr.fn_regex_matches - Custom regex function, returns the matching collection;
  • clr.fn_regex_replace - Custom regex function, advanced replace based on regular expressions;
  • clr.fn_regex_instr - Custom regex function, returns the postion of regex expression in a string;
  • clr.fn_regex_substr - Custom regex function, rerurns a substring in string based on regex expression;
  • clr.fn_regex_like - Custom regex function, advanced like based on regular expressions (synonym of clr.fn_regex_ismatch);
  • clr.fn_regex_occurs - Custom regex function, advanced occurs based on regular expressions;

Conversion
  • dbo.ascii2ebcdic - Helper table, helps converts strings to and from EBCDIC and ASCII;
  • tsql.fn_date2ts - Converts date to timestamp of given precission, synonym of fn_timestamp
  • tsql.arab2roman - Custom function, converts arab to roman numerals;
  • tsql.fn_dec2oct - Custom function, converts decimal to octal numbers;
  • tsql.fn_dec2hex - Custom function, converts decimal to hexadecimal numbers;
  • tsql.fn_dec2bin - Custom function, converst decimal to binary numbers;
  • tsql.fn_deg2grad - Custom function, converts degrees to grads;
  • tsql.fn_grad2deg - Custom function, converts grads to degrees;
  • tsql.fn_grad2rad
  • tsql.fn_hijri2gregorian
  • tsql.fn_gregorian2hijri
  • tsql.fn_base2base
  • tsql.fn_celsius2fahrenheit
  • tsql.fn_fahrenheit2celsius
  • tsql.fn_celsius2kelvin
  • tsql.fn_kelvin2celsius

Date
  • tsql.fn_month_first_day - Custom function, returns the first day of the month as DATE;
  • tsql.fn_month_last_day - Custom function, returns the last day of the month as DATE;
  • tsql.fn_timestamp - Custom function, returns the time stamp as YYYYMMDDHHNNSSMSS;
  • tsql.fn_date2ts - Converts date to timestamp of given precission, synonym of fn_timestamp
  • tsql.fn_elapsed_time - Custom function, returns a string with elapsed time including days;
  • tsql.fn_age - Custom function, calculates the age of a person based on DOB and date;
  • tsql.fn_week_first_day - Custom function, returns the first day of week date
  • tsql.fn_week_last_day - Custom function, returns the last day of week date
  • tsql.fn_quarter_first_day - Custom function, returns the first day of quarter date
  • tsql.fn_quarter_last_day - Custom function, returns the last day of quarter date
  • tsql.fn_year_first_day - Custom function, returns the first day of year date
  • tsql.fn_year_last_day - Custom function, returns the last day of year date
  • tsql.fn_quarter_day - Custom function, returns the day of quarter number
  • tsql.fn_quarter_month - Custom function, returns the month of quarter number
  • tsql.fn_datename2no - Custom function, returns the coresponding number of month/day name;


Numeric
  • tsql.fn_avg_val - Custom function, returns the avg value from a sepparated list;
  • tsql.fn_min_val - Custom function, returns the min value from a sepparated list;
  • tsql.fn_max_val - Custom function, returns the max value from a sepparated list;
  • tsql.fn_median_val - Custom function, returns the median (middle) value in a sepparated list;
  • tsql.fn_range_val - Custom function, returns the range (max-min) value in a sepparated list;
  • tsql.fn_nth_root - Custom function extracts the nth root of a number, similar to SQRT();


Logical
  • tsql.fn_iif - VB like IIF(immediate IF) function;
  • tsql.fn_isnull_or_empty - Custom function, checks if a value is null or empty;
  • tsql.fn_isalpha - Custom function, checks if string is alphanumeric;
  • tsql.fn_isbinary - Custom function, checks if a value is binary;
  • tsql.fn_iseven - Custom function, checks if number is EVEN;
  • tsql.fn_isodd - Custom function, checks if number is ODD;
  • tsql.fn_ishex - Custom function, checks if number is HEXADECIMAL;
  • tsql.fn_isinteger - Custom function, checks if number is INT;
  • tsql.fn_ispositive - Custom function, checks if number is POSITIVE;
  • tsql.fn_isnegative - Custom function, checks if number is NEGATIVE;
  • tsql.fn_isoctal - Custom function, checks if number is OCTAL;
  • tsql.fn_isprime - Custom function, checks if number is PRIME;
  • tsql.fn_isroman - Custom function, checks if number is ROMAN numeral;
  • tsql.fn_xor - Custom function, performs XOR(Exclusiv OR) operation;

Array
  • tsql.fn_split - Visual Basic like SPLIT funtion, return a table with indexed values;
  • tsql.fn_split_xt - Visual Basic like SPLIT function with additional features: text qualifier and item no;
  • clr.fn_regex_split - Visual Basic like SPLIT function with advanced RegEx capabilities;

DML
  • tsql.sp_data_compare - Custom proc, compares dat ain 2 tables/views and returns the diffs;
  • tsql.sp_smart_delete - Custom proc, deletes data in a table using best possible method;
  • tsql.sp_dedup - Custom proc, deletes duplicate records from a specified table;
  • tsql.sp_partition_truncate - Custom proc, truncates data in a gived partition of a table;
  • tsql.sp_values_truncate - Custom proc, truncates data in a partitioned table based on value;
  • tsql.sp_xtab - MsAccess like procedure, offers CrossTab query functionality, alternative to PIVOT;
  • tsql.fn_recs_gen - Custom function, simple records generator, includes randon number column;

DDL
  • tsql.sp_table_definition - Custom proc, returns the DML for a given table;
  • tsql.sp_index_definition - Custom proc, returns the DML for a given index;
  • tsql.sp_contraint_definition - Custom proc, returns the DML for a given constraint;
  • tsql.sp_pk_definition - Custom proc, returns the DML for a given PK;
  • tsql.sp_fk_definition - Custom proc, returns the DML for a given FK;
  • tsql.sp_partionion_scheme_name - Custom proc, returns the partition scheme name for a table;
  • tsql.sp_partionion_column_name - Custom proc, returns the partition scheme name for a table;
  • tsql.sp_filegroup_name - Custom proc, returns the filegroup name for a table;
  • tsql.sp_schema_compare - Custom proc, returns the filegroup name for a table;

Custom Aggregate
  • clr.fn_list_agg - Custom function, merges the existing rows into a delimited string in a Group by;
  • clr.fn_median - Custom function, calculated the middle value in a Group BY;
  • clr.fn_mode - Custom function, calculates the most common value in a Group By
  • clr.fn_range - Custom function, calculates the max - min in a Group By
  • clr.fn_first - Custom function, return first element(s) in a Group By
  • clr.fn_last - Custom function, returns last element(s) in a Group By
  • clr.fn_nth - Custom function, returns the nth element in a Group By

Other
  • clr.fn_levenshtein
  • clr.fn_damerau_levenshtein
  • clr.fn_jaro_winkler
  • clr.fn_win_eventlog
  • tsql.fn_file_exists
  • tsql.fn_rnd - LCG type random numer generator, can be used in UDF unlike RAND() ;
  • clr.fn_compress - compress a (var)binary data
  • clr.fn_decompress - decompress a (var)binary data

Last edited Nov 29, 2012 at 1:36 PM by adudau, version 70

Comments

No comments yet.