Usage of SQL Functions in Different Databases

MySQL, Oracle and MS SQL Server are different Relational Database Management Systems that widely used. SQL or Structured Query Language is the only language that used to communicate all the above three databases. MySQL and Oracle databases are maintained by Oracle where as Microsoft is taking care of MS SQL Server database. But we observed some difference in usage of functions all the three databases.

Oracle	MySql	SQLServer
SUBSTR	SUBSTRING	SUBSTRING
INSTR	LOCATE	CHARINDEX
LENGTH	LENGTH	LEN
Concat(\|\|)	Concat(\|\|)	Concat(+)
sysdate()	now()	getdate()
nvl	IFNULL	ISNULL
rownum	LIMIT	TOP

Comments

Photo : Savitri during her last days

Even after 4 decades of her death, people are very much interested to watched her (Savitri) biopic. Mahanati turned to be stupendous success. On eve of remembering Savitri, here we posted Savitri photo. The photo seems her last days. The man stand behind Savitri is Gemini Ganeshan who married Savitri. It seems that she suffered bad days during her last days.

PK Fans - Political and Private life

Pawan Kalyan fans attack Director Ram Gopal Varma's office for making parody film "Power Star" on their hero. RGV made a complaint and withdraw later for unknown reasons.

Maradona’s doctor escapes preventive detention

Reasons for the death of few celebrities will always suspicious. Legendary American Singer Michael Jackson’s death was a homicide. Jackson died from the combination of drugs in his body, with the most significant drugs being the anesthetic propofol and the anxiolytic lorazepam.

A2Z

Search This Blog