|
|
SQL Server T-SQL User-Defined Function of the Week Archive
or checkout the UDF FAQ or
UDF Home
Volume 2:
| Issue |
Date |
UDF, SP, or topic |
|
Vol 2 #50 |
Dec 21, 2004 |
Query
Analyzer Templates |
|
Vol 2 #49 |
Dec 14, 2004 |
instring |
|
Vol 2 #48 |
Dec. 7, 2004 |
udf_Addr_Zip5ToST |
|
Vol 2 #47 |
Nov. 30, 2004 |
udf_Bank_IsLuhn |
|
Vol 2 #46 |
Nov. 23, 2004 |
udf_Tbl_PinnedTAB |
|
Vol 2 #45 |
Nov. 16, 2004 |
dba_Tbl_PinListedTables |
|
Vol 2 #44 |
Nov. 9, 2004 |
Comparison of Rot13 functions |
|
Vol 2 #43 |
Nov. 4, 2004 |
ufn_Rot13Redux |
|
Vol 2 #42 |
Oct. 26, 2004 |
ufn_Rot13 |
|
Vol 2 #41 |
Oct. 19, 2004 |
udf_Sys_RegReadStr |
|
Vol 2 #40 |
Oct. 12, 2004 |
Future of the Newsletter |
|
Vol 2 #39 |
Oct. 5, 2004 |
udf_Tbl_PKeyMissingTAB |
|
Vol 2 #38 |
Sept. 21 2004 |
Column
Permissions |
|
Vol 2 #37 |
Sept. 14, 2004 |
Updatable
View to replace a column |
|
Vol 2 #36 |
Sept. 7, 2004 |
Replacing a column a UDF to do a lookup. |
|
Vol 2 #35 |
Aug. 17, 2004 |
udf_Num_SequenceTAB |
|
Vol 2 #34 |
Aug. 10, 2004 |
fnc_10_parse_string |
|
Vol 2 #33 |
Aug. 3, 2004 |
udf_Login_ServerRolesTAB |
|
Vol 2 #32 |
July 27, 2004 |
udf_Job_FailedTAB |
|
Vol 2 #31 |
July 20, 2004 |
udf_DB_BackupDate |
|
Vol 2 #30 |
July 13, 2004 |
udf_Tbl_ColNameIssueTAB |
|
Vol 2 #29 |
July 6, 2004 |
udf_SQL2K_IsKeywordBIT |
|
Vol 2 #28 |
June 29, 2004 |
udf_VBNET_IsKeywordBIT |
|
Vol 2 #27 |
June 22, 2004 |
udf_Tbl_ColCountTAB |
|
Vol 2 #26 |
June 15, 2004 |
formatdate |
|
Vol 2 #25 |
June 8, 2004 |
udf_DT_ToDecimalMMYY |
|
Vol 2 #24 |
June 1, 2004 |
udf_DT_FromDecimalMMYY |
|
Vol 2 #23 |
May 25, 2004 |
udf_DT_ToDecimal |
|
Vol 2 #22 |
May 18, 2004 |
udf_DT_FromDecimal |
|
Vol 2 #21 |
May 11, 2004 |
udf_Tbl_ColNotPortable |
|
Vol 2 #20 |
May 4, 2004 |
udf_Rep_IsReplica |
|
Vol 2 #19 |
Apr 27, 2004 |
udf_UDT_UsedTAB |
|
Vol 2 #18 |
Apr 20, 2004 |
udf_Tbl_GUIDColumnsTAB |
|
Vol 2
#17 |
Apr 13, 2004 |
udf_Tbl_TimeStampColumnsTAB |
|
Vol 2 #16 |
Apr 6, 2004 |
udf_CompleteWeekRange |
|
Vol 2 #15 |
Mar 30, 2004 |
udf_DT_HoursInDayNA |
|
Vol 2 #14 |
Mar 23, 2004 |
udf_DT_NthDayInMon |
|
Vol 2 #13 |
Mar 16, 2004 |
udf_Tbl_ColPotentialProblems |
|
Vol 2 #12 |
Mar 9, 2004 |
udf_Tbl_ColInfoTAB |
|
Vol 2
#11 |
Mar 2, 2004 |
udf_Tbl_ColDescriptionsTAB |
|
Vol 2 #10 |
Feb 24, 2004 |
udf_EP_AllTableLevel2EPsTAB |
|
Vol 2 #9 |
Feb 17, 2004 |
udf_Num_ToWords |
|
Vol 2 #8 |
Feb 10, 2004 |
Debugging UDFs |
|
Vol 2 #7 |
Feb. 3, 2004 |
udf_Tbl_TriggerStatusTAB |
|
Vol 2 #6 |
Jan 27, 2004 |
udf_Num_Pi |
|
Vol 2 #5 |
Jan 16, 2004 |
udf_Num_Phi |
|
Vol 2 #4 |
Dec 9, 2003 |
udf_Num_NthRoot |
|
Vol 2 #3 |
Dec. 2, 2003 |
udf_DT_FromJulian |
|
Vol 2 #2 |
Nov. 26, 2003 |
udf_DT_ToJulian |
|
Vol 2 #1 |
Nov. 18, 2003 |
Computed Columns using UDFs |
Volume 1 (Complete):
| Issue |
Date |
Function Name |
|
Vol 1
#52 |
Nov. 12, 2003 |
udf_TxtN_SingleSpace |
|
Vol 1 #51 |
Nov. 4, 2003 |
udf_Func_MayIExec |
|
Vol 1 #50 |
Oct. 28, 2003 |
asciichars |
|
Vol 1
#49 |
Oct. 21, 2003 |
udf_Instance_FilesTAB |
|
Vol 1 #48 |
Oct. 14, 2003 |
formatnumber |
|
Vol 1 #47 |
Oct. 7, 2003 |
Proper |
|
Vol 1 #46 |
Sept 30, 2003 |
NumberToWords |
|
Vol 1 #45 |
Sept 23, 2003 |
Percentile Functions |
|
Vol 1 #44 |
Sept 16, 2003 |
udf_Process_NetLib |
|
Vol 1 #43 |
Sept 9, 2003 |
udf_Tbl_ColumnList |
|
Vol 1
#42 |
Sept. 2, 2003 |
udf_Proc_BadPasswordTAB |
|
Vol
1 #41 |
August 26, 2003 |
udf_SQL_PasswordIsStrong |
|
Vol 1
#40 |
August 19, 2003 |
udf_Txt_HasCharInGroup |
|
Vol 1 #39 |
August 12, 2003 |
udf_Instance_CPU_BUSY_Percent |
|
Vol 1 #38 |
August 5, 2003 |
udf_DT_AddTime |
|
Vol 1
#37 |
July 29, 2003 |
udf_Perf_FS_ByDBTAB |
|
Vol 1 #36 |
July 22, 2003 |
udf_DT_FileNameFmt |
|
Vol 1 #35 |
July 15, 2003 |
udf_Trig_TANH |
|
Vol 1 #34 |
July 8, 2003 |
udf_Num_FP_Equal |
|
Vol 1 #33 |
July 1, 2003 |
udf_Func_TableCols |
|
Vol 1 #32 |
June 24, 2003 |
Testing udf_Txt_CharIndexRev |
|
Vol 1 #31 |
June 17, 2003 |
udf_DT_Round2Part |
|
Vol 1
#30 |
June 10, 2003 |
udf_Example_JoinDesc |
|
Vol 1 #29 |
June 3, 2003 |
udf_Txt_SplitTAB |
|
Vol 1
#28 |
May 27, 2003 |
fn_replbitstringtoint and udf_BitS_ToInt |
|
Vol 1 #27 |
May 20, 2003 |
fn_dblog |
|
Vol 1 #26 |
May 13, 2003 |
fn_varbintohexstring
|
|
Vol 1
#25 |
May 6, 2003 |
udf_Proc_WithRecompile
|
|
Vol 1 #24 |
Apr 29, 2003 |
udf_Bit_Int_NthBIT
|
|
Vol 1
#23 |
Apr 22, 2003 |
fn_replinttobitstring and udf_BitS_FromInt
|
|
Vol 1
#22 |
Apr 15, 2003 |
System UDFs and fn_chariswhitespace
|
|
Vol 1 #21 |
Apr 8, 2003 |
udf_Num_RandInt and udf_Orders_RandomRow
|
|
Vol 1 #20 |
Apr 1, 2003 |
udf_SQL_RuntimeFee
|
|
Vol 1 #19 |
Mar 25, 2003 |
udf_View_ColumnsIndexableTAB
|
|
Vol 1
#18 |
Mar 18, 2003 |
udf_SQL_DataTypeString
|
|
Vol 1
#17 |
Mar 11, 2003 |
udf_SQL_SystemUDFText
|
|
Vol 1 #16 |
Mar 4, 2003 |
udf_Txt_FullLen
|
|
Vol 1
#15 |
Feb 25, 2003 |
udf_SQL_DefaultsTAB
|
|
Vol 1 #14 |
Feb 18, 2003 |
fn_get_sql
|
|
Vol 1 #13 |
Feb 11, 2003 |
udf_SQL_SearchDBObjectsTAB
|
|
Vol 1 #12 |
Feb 4, 2003 |
udf_SQL_VariantToDatatypeName
|
|
Vol 1 #11 |
Jan 28, 2003 |
udf_SQL_StartDT
|
|
Vol 1
#10 |
Jan 21, 2003
Updated
June 20, 2003 |
udf_Txt_CharIndexRev
|
|
Vol 1 #9 |
Jan 13, 2003 |
udf_FactorialsTAB
|
|
Vol 1
#8 |
Jan 6, 2003 |
udf_Tbl_PKeyColumnsTAB
|
|
Vol 1
#7 |
Dec 30, 2002 |
udf_DT_DynamicDATEPART
|
|
Vol 1
#6 |
Dec 23, 2002 |
udf_SQL_UserMessagesTAB
|
|
Vol 1 #5 |
Dec 16, 2002 |
udf_Tbl_RowCount
|
|
Vol 1 #4 |
Dec 9, 2002 |
udf_TxtN_Wrap
|
|
Vol 1
#3 |
Dec 6, 2002
(Bonus Issue) |
udf_DT_WeekdaysBtwn
|
|
Vol 1 #2 |
Dec 4, 2002
(Bonus Issue) |
udf_DT_CurrTime
|
|
Vol
1 #1 |
Dec 2, 2002 |
udf_SQL_Tbl_NotOwnedbyDBOTAB
|
|
|
