convert() function in sql codebarlet.com 10 Jan 2012 | 12:31 am

This function in sql server is used for mostly two reasons; to convert one datatype into another datatype or for conversion of date/time formats. So you can convert integer to varchar, varchar to date...

SQL REVERSE sql-statements.com 11 Dec 2011 | 04:26 pm

SQL REVERSE function is used to return reverse of a string. It’s supported by MS SQL Server, MySQL. Oracle supports it too, but maybe not in the documents. SQL REVERSE function Syntax SQL REVERSE fu...

SQL LEFT Function sql-statements.com 5 Dec 2011 | 01:03 pm

SQL LEFT() function is used to get left part of a string with the length of specified number. It is supported by MySQL, MS SQL Server, Access, but not by Oracle. SQL LEFT Function Syntax Note: 1, I...

Permutasi programmervb.blog.com 17 May 2008 | 05:05 pm

Option Explicit Dim id As Integer Dim N As Integer Dim perm() As Integer Function Engine(i As Integer) Dim t As Integer Dim j As Integer id = id + 1 perm(i) = id If (id = N...

SQL split function svendtofte.com 9 Mar 2009 | 07:08 pm

Every time I need to work with SQL, it never ceases to amaze. The language is simply such an abortion in terms of development enviroments and simple programmer usability. Naturally, alot of this stems...

SQL First Function Equivalent in SQL Server and Oracle geeklad.com 19 Feb 2012 | 11:01 am

Microsoft Access is nice for quick and dirty manipulation of data and merging data sets. It also has a lot of nice functions you won’t find in other versions of SQL. One of these functions is the Firs...

SQL First Function Equivalent in SQL Server and Oracle geeklad.com 19 Feb 2012 | 06:01 am

Microsoft Access is nice for quick and dirty manipulation of data and merging data sets. It also has a lot of nice functions you won’t find in other versions of SQL. One of these functions is the Firs...

Sql Server Function Returns date in YYYYMMDD Format smsaxena.blogspot.in 16 Aug 2012 | 09:00 pm

Create FUNCTION [dbo].[fn_YMDDate] ( @dateParam     varchar(10) ) RETURNS Varchar(10) AS BEGIN DECLARE @Return Varchar(10) Declare @YYYY  varchar(4) Declare @MM  varchar(2) Declare @DD  varchar(2) De...

MS SQL server Function to read response from Http mkmpvtltd.eu.pn 3 Feb 2013 | 10:40 am

T-SQL LEN() function alternative if the trailing spaces count is important for you. rantsonsoftware.com 4 Nov 2012 | 07:03 pm

In T-SQL, the LEN() function is used to determine the length of the string, which is commonly used by database testers, do you know it doesn’t count trailing spaces? but it will count the leading spac...