Atlanta Custom Software Development 

 
   Search        Code/Page
 

User Login
Email

Password

 

Forgot the Password?
Services
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
Programming
VB VB (1648)
VB.net VB.net (736)
C# C# (15)
ASP.net ASP.net (779)
ASP ASP (41)
VC++ VC++ (25)
PHP PHP (0)
JAVA JAVA (4)
JScript JScript (5)
  Database
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
Automation
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
OS/Networking
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
Graphics
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
Links
» ASP.net (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» VB.net (4)
» VC (3)
» HTML/CSS/JavaScript (10)
Tools
» Regular Expr Tester
» Free Tools

 

Meta Data User-Defined Functions
Total Hit (1902) 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 (2015) 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 (3160) 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 (2077) 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 (2331) 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
Scalar Function Example.
Total Hit (1975) This sample shows several ways to call a scalar function in T-SQL.
Rating
UDF in CHECK & DEFAULT CONSTRAINTS.
Total Hit (2310) 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
How to perform case-sensitive searches on a case-insensitive server/table/column?
Total Hit (2100) This shows some of the cool, powerful techniques of SQL2000 viz. COLLATION, BINARY_CHECKSUM functions.
Rating
Regular Expressions in T-SQL
Total Hit (3090) 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
MD5 Algorithm implementation in T-SQL
Total Hit (8599) MD5 is very secure one way encryption. You can use MD5 to encrypt passwords stored in database.
Rating
UDF : ParseArray - return table from CSV
Total Hit (2720) 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
RC4 Encryption/Decryption Algorithm as a UDF to encrypt/decrypt sensitive data in SQL Server
Total Hit (8459) This code is written by Brad Baker and Mike Arney «code LangId=6»SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GO if exists (select * from sysobjects where id = object_id(N'[dbo].[fn_string_helper]') and (OBJECTPROPERTY(id, N'IsTableFunction') + OBJECTPROPERTY(id, N'IsInlineF ....Read More
Rating
This is a link to a different site A better Soundex code
Total Hit (779) 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
This is a link to a different site fn_formatdatetime (Format a datetime variable with a user-defined string)
Total Hit (689) This UDF will take a datetime variable and a varchar format string variable. It will then pass back the date/time formated according to the format string. This is similar to the CONVERT function, but you are not limited to the predefined types of it. It works more like the Format function of VB/V ....Read More
Rating
This is a link to a different site Find Out What They're Doing with fn_get_sql
Total Hit (917) 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


Recommanded Links

 

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.