what is difference between Microsoft sql server and oracle?

Question

Both are good database and which one is the most better choice for a programmer

Answer 1

In terms of writing SQL queries, there's almost no difference...just the names of some functions (like date/time conversions) and SQL extensions (for example, where Oracle uses LIMIT, SQL Server uses TOP.) The syntax differences are much more significant when comparing the scripting languages (PL/SQL vs T-SQL)



As to which is better, that all depends on what you think your employment target is...Oracle is more designed for large-scale Enterprise-level applications while SQL Server for midrange and desktop users.

Answer 2

Microsoft SQL Server 2008 provides a data platform with many advantages and business benefits including better security, performance and scalability, developer productivity and oracle is best for Performance and Scalability..

Answer 3

Oracle is an RDBMS while SQL is the language used to access most modern databases

Answer 4

sq. is a programming language with quite a few implementations. 2 of the main regular commercial sq. implementations are from Oracle and Microsoft; your "sq. Oracle" would be Oracle's version, your "sq. server" would be Microsoft's product. the concepts and code at the back of the two are tremendously lots same. the place they variety is the way they're wrapped up and used, so like a BMW and a Mercedes the two have parking breaks, on the BMW you employ it alongside with your hand and on the Mercedes you employ your foot. seen ordinary is a Microsoft programming language, used (misused for my area) in the two coaching and in development in-domicile applications. The .internet area of the call refers to a set of technologies that seen ordinary makes use of and which may additionally combine in somewhat some techniques with Microsoft sq. Server. sq. is used to save records interior of an application, even though it may hardly be used to create an application in itself. seen ordinary is one technologies you ought to apply to create an complete application around a sq. database. Oracle does not fairly have an equivalent of seen ordinary. the two companies do have extra desirable programming languages, Oracle has a Java and Microsoft C#, the two one in all which fulfil comparable roles and for my area woudl be extra smart to learn than seen ordinary.

Answer 5

u r write both r good database but choice is depend on your programming language....

like dot net is more compatible with Sql Server n java is compatible with Oracle.....

Answer 6

There is no better choice. Whichever you prefer is the best choice.