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.

Police Attacked Asaduddin Owaisi - Rarest Photo

Asaduddin Owaisi make mockery at Muslims!

Asaduddin Owaisi who is president of All India Majlis-e-Ittehadul Muslimeen is playing crucial hidden role in TRS Government. MIM was friendly ally to Congress once in United Andhra Pradesh. 12% Minorities turns to be vote bank to Congress in every elections. MIM was openly supported Congress to counter BJP. But people are seeing very difficult situation in Telangana state. Congress is in opposition in Telangana and BJP comes to fourth position as per 2014 results. Though TRS was not in NDA, but KCR political movements seems to be close to BJP in every aspect. At the time of No-Confidence motion TRS voted for BJP government where as MIM voted against BJP. But both MIM and TRS were in good understanding in Telangana and diversified political stand at Central. During the time of Deputy Chairman for Rajya Sabha too TRS voted in favor of NDA nominee and MIM voted for Congress nominee. Now the question among many muslim voters why Owaisi brothers go along with TRS though know KCR main...

A2Z

Search This Blog