 |
Meta Data User-Defined Functions
|
| Total Hit (2599) |
Introduction
Meta Data UDFs
COL_LENGTH2
COL_ID
INDEX_ID
INDEX_COL2
ROW_COUNT
--------------------------------------------------------------------------------
Introduction
I would like to write the series of articles about useful User-Defined Functions grouped by the following
....Read More |
Rating
 |
|
|
|
Mathematical User-Defined Functions
|
| Total Hit (2612) |
Introduction
Mathematical UDFs
Factorial
PercentFrom
PercentValue
Degree
Allocation
Combination
--------------------------------------------------------------------------------
Introduction
I would like to write the series of articles about useful User-Defined Functions gro
....Read More |
| Rating
|
|
|
|
Date and Time User-Defined Functions
|
| Total Hit (3842) |
Introduction
Date and Time UDFs
DatePart
TimePart
GetWorkingDays
AddWorkingDays
FirstMonthDay
LastMonthDay
--------------------------------------------------------------------------------
Introduction
I would like to write the series of articles about useful User-Defined Fu
....Read More |
| Rating
|
|
|
|
String User-Defined Functions
|
| Total Hit (2623) |
Introduction
String UDFs
StrIns
StrDel
StrSeparate
StrCHARINDEX
StrREPLACE
StrREVERSE
«B»Introduction«/B»
I would like to write the series of articles about useful User-Defined Functions grouped by the following categories:
==>Date and Time User-Defined Functions
==>Mat
....Read More |
| Rating
|
|
|
|
Some useful UDF for SQL Server 2000
|
| Total Hit (2914) |
Introduction
UDF examples
Database creation date
Date the object was created
Get date part of datetime value
Get time part of datetime value
Get the number of working days between two dates
«B»Introduction«/B»
SQL Server 2000 supports User-Defined Functions (UDFs) - one or more Tr
....Read More |
| Rating
|
|
|
|
|
|
UDF in CHECK & DEFAULT CONSTRAINTS.
|
| Total Hit (3262) |
User-defined functions in SQL2000 provide a powerful way to reuse code / logic. This example shows how you can use UDFs in CHECK & DEFAULT constraints of a table.
|
| Rating
|
|
|
|
|
|
Regular Expressions in T-SQL
|
| Total Hit (3941) |
For this solution we need SQL Server 2000 or higher. Also we need to make sure we have the VBScript.RegExp library on our computer. This should come with most Windows 2000 servers, in the Windows Scripting package. If you are using this on an older version of Windows, you will probably have to downl
....Read More |
| Rating
|
|
|
|
|
|
UDF : ParseArray - return table from CSV
|
| Total Hit (3509) |
Sometimes we may need to store values in one field using some sort of seperating character. For example if you want to store multiple values in one field instead of normalizing your table and creating a whole new table to store multiple records. This articles will show you how you can create a UDF w
....Read More |
| Rating
|
|
|
|
|
|
A better Soundex code
|
| Total Hit (1036) |
Terms that are often misspelled can be a problem for database designers. Names, for example, are variable length, can have strange spellings, and they are not unique. American names have a diversity of ethnic origins, which give us names pronounced the same way but spelled differently and vice versa
....Read More |
| Rating
|
|
|
|
|
|
Find Out What They're Doing with fn_get_sql
|
| Total Hit (1112) |
Not only did SQL Server 2000 introduce the concept of user-defined functions (UDF) but also Microsoft's development team created several such functions as part of the database product. In addition to many undocumented system UDFs, used internally by SQL Server, the product release has nine documente
....Read More |
| Rating
|
|