List of Features


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 sepparated list;
  • tsql.fn_max_val - Custom function, returns the max value from a sepparated list;
  • tsql.fn_format - MsExcel/Access like function, formats string using commen formats;
  • tsql.fn_word_count - Custom function, counts the number of words in a string;
  • tsql.sp_join - VB like function, merges records in a delimited 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;

Conversion
  • dbo.ascii2ebcdic - helper table, helps convert a string to and from EBCDIC and ASCII;
  • 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_age - Custom function, calculates the age of a person based on DOB and date;
  • tsql.fn_timestamp - Custom function, returns the time stamp as YYYYMMDDHHNNSS;
  • tsql.fn_elapsed_time - Custom function, returns a string with elapsed time including days;

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_sec
  • tsql.fn_sin
  • tsql.fn_cos
  • tsql.fn_tan
  • tsql.fn_atan
  • tsql.fn_cotan

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 - Custom proc, returns the partition scheme name for a table;
  • tsql.sp_filegroup_definition - 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_accumulate - Custom function, merges the existing rows into a sepparated string based on WHERE;

Other
  • tsql.fn_levenshtein_distance
  • tsql.fn_file_exists

Last edited Aug 23, 2012 at 6:06 PM by adudau, version 12

Comments

No comments yet.