SQL Function Reference:Oracle vs.SQL Server vs. My SQL Part- II

By -
String Functions

Function - Convert character to ASCII
Oracle - ASCII
SQL Server - ASCII
My Sql - ASCII

Function -String concatenate
Oracle - CONCAT
SQL Server - (expression + expression)
My Sql - CONCAT

Function -Convert ASCII to character
Oracle - CHR
SQL Server - CHAR
My Sql - CONCAT

Function -Return starting point of character in character string (from left)
Oracle - INSTR
SQL Server - CHARINDEX
My Sql - INSTR

Function -Convert characters to lowercase
Oracle - LOWER
SQL Server - LOWER
My Sql - LOWER

Function -Convert characters to uppercase
Oracle - UPPER
SQL Server - UPPER
My Sql - UPPER


Function -Pad left side of character string
Oracle - LPAD
SQL Server - N/A
My Sql - LPAD

Function -Remove leading blank spaces
Oracle - LTRIM
SQL Server - LTRIM
My Sql - LTRIM


Function -Remove trailing blank spaces
Oracle - RTRIM
SQL Server -RTRIM
My Sql - RTRIM

Function -Starting point of pattern in character string
Oracle - INSTR
SQL Server -PATINDEX
My Sql - INSTR

Function -Repeat character string multiple times
Oracle - RPAD
SQL Server -REPLICATE
My Sql - RPAD

Function -Phonetic representation of character string
Oracle - SOUNDEX
SQL Server -SOUNDEX
My Sql - SOUNDEX

Function -String of repeated spaces
Oracle - RPAD
SQL Server -SPACE
My Sql - RPAD

Function -Character data converted from numeric data
Oracle - TO_CHAR
SQL Server -STR
My Sql - Need To Update

Function - Substring
Oracle - SUBSTR
SQL Server -SUBSTRING
My Sql - MID

Function - Replace characters
Oracle - REPLACE
SQL Server -STUFF
My Sql - REPLACE

Function - Capitalize first letter of each word in string
Oracle - INITCAP
SQL Server -N/A
My Sql - Need To Update

Function - Translate character string
Oracle -TRANSLATE
SQL Server -N/A
My Sql - Need To Update

Function - Length of character string
Oracle -LENGTH
SQL Server - DATALENGTH or LEN
My Sql - LENGTH

Function - Greatest character string in list
Oracle -GREATEST
SQL Server - N/A
My Sql - Need To Update

Function - Least character string in list
Oracle -LEAST
SQL Server - N/A
My Sql - Need To Update

Function - Convert string if NULL
Oracle -NVL
SQL Server - ISNULL
My Sql - Need To Update

Visit Part III (Date Functions)

Comments

Post a Comment

Popular posts from this blog

How to add Primary Key and Auto Increment on different fields of MySql

By -
 Normal code generated by MySql:- CREATE TABLE `categorymaster` (   ` CategoryID ` int(11) NOT NULL AUTO_INCREMENT,   ` Category ` varchar(200) DEFAULT NULL,   `IsActiv` int(11) DEFAULT NULL,   `ImagePath` varchar(200) DEFAULT NULL,   `DisplayOrder` int(11) DEFAULT NULL,   PRIMARY KEY (` Category `) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; In the above data stucture I want to make the " Category " as Primary Key and " CategoryId " as Auto Increment. But Table Wizard always give errors so, I decided to write my own Statement. Following is the statement which will create perfect structure according to my requirement. DROP TABLE `dbname`.`categorymaster`; CREATE TABLE `categorymaster` (   `CategoryId` int(11) unsigned NOT NULL AUTO_INCREMENT,   `Category` varchar(200) DEFAULT NULL,   `IsActiv` int(11) DEFAULT NULL,   `ImagePath` varchar(200) DEFAULT NULL,   `DisplayOrder` in...
Read more

URL rewriting and SEO

By -
Image
Download c# code What is URL REWRITING? URL rewriting is the process of intercepting an incoming Web request and redirecting the request to a different resource. When performing URL rewriting, typically the URL being requested is checked and, based on its value, the request is redirected to a different URL. For example, in the case where a website restructuring caused all of the Web pages in the /people/ directory to be moved to a /info/employees/ directory, you would want to use URL rewriting to check if a Web request was intended for a file in the /people/ directory. If the request was for a file in the /people/ directory, you'd want to automatically redirect the request to the same file, but in the /info/employees/ directory instead. Common Uses of URL Rewriting Creating data-driven ASP.NET websites often results in a single Web page that displays a subset of the database's data based on querystring parameters. For example, in designing an e-commerce site, one of your tasks ...
Read more

Sql azure select from another database / Cross Database connection

By -
Cross database query Sql Azure Azure cross database query performance sql azure select from another database reference to database and/or server name in is not supported in this version of sql server. All the above statements are reference to the issue we face while shifting data from Sql Server to Azure Database. While using Sql Server (Any version) we can reference any database with in Sql server according to user rights assigned to user. We can use statements like "select * from db1.dbo.customers" But now in Sql Azure the system and terminology has changed. Now, azure has new concept of External Tables  and sp_execute_remote  in introduced. Now we need to know the who is who in Azure. External Tables = "Is for Select" sp_execute_remote="Execute External Store Procedures" Before proceeding. Please create 2 azure databases as per your choice. Here I am naming them as. DbCustomers and DbPayments  and keep a reference to them ...
Read more