Posts From June, 2009

SP_Kill_Users 

Posted by Philip Leitch Saturday, June 13, 2009 6:22:49 AM Categories: Database Administration Procedure

Kills all processes currently using a specified database, or all databases if no database is supplied.

... read more
 

Time To Text 

Posted by Philip Leitch Thursday, June 11, 2009 7:30:03 PM Categories: Date and Time Scalar Function String
isplays just the time component of a datetime/smalldatetime value.
... read more
 

Tax Component 

Posted by Philip Leitch Sunday, June 7, 2009 7:59:48 AM Categories: Currency Scalar Function

Determines the tax component of an already taxed value.

... read more
 

OverlapDates 

Posted by Philip Leitch Sunday, June 7, 2009 5:46:18 AM Categories: Date and Time Scalar Function

Determines if one pair of dates overlaps with another pair of dates.

... read more
 

Text_To_Base64 

Posted by Philip Leitch Friday, June 5, 2009 3:21:18 AM Categories: Base64 Scalar Function String

Converts Base 256 Ascii characters (text or not) to Base64 characters

... read more
 

Base64_To_Text  

Posted by Philip Leitch Friday, June 5, 2009 3:16:47 AM Categories: Base64 Scalar Function String

Converts Base 64 text to standard Ascii characters (text or not)

... read more
 

Upper_Bound 

Posted by Philip Leitch Thursday, June 4, 2009 9:57:56 PM Categories: Scalar Function String

Finds the last entry in a string based on a delimiter element. This is normally used with the split function to iterate through all entries.

... read more
 

Split 

Posted by Philip Leitch Thursday, June 4, 2009 9:53:46 PM Categories: Scalar Function String

Creates an ability to split a varchar (string) into an array and access specific elements of that array.

... read more
 

ShortTime 

Posted by Philip Leitch Thursday, June 4, 2009 9:49:56 PM Categories: Date and Time Scalar Function

Returns just the time component of a datetime or smalldatetime variable.

... read more
 

ShortDate 

Posted by Philip Leitch Thursday, June 4, 2009 9:36:50 PM Categories: Date and Time Scalar Function

 Returns just the date component of a datetime or smalldatetime variable.

... read more
 
Copyright 2009 Philip Leitch