What is the difference between sql, mysql and sql server?



What is the difference between sql, mysql and sql server?..

Answer / Nitish Raj

SQL (Structured Query Language) is a standard language for querying and managing databases. MySQL and SQL Server are two popular relational database management systems that use SQL to interact with their databases. Differences include: MySQL is open-source, while SQL Server is proprietary software; MySQL uses the InnoDB engine by default, while SQL Server uses its own storage engines like Heap and Table; MySQL supports a maximum of 64KB for a single column, while SQL Server has no such limit.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is sp_pkeys? : Transact sql

1 Answers  


What is dml with example?

1 Answers  


Give the structure of the procedure ?

1 Answers  


Can a table have no primary key?

1 Answers  


What is numeric function sql?

1 Answers  


what are the disadvantages of mysql? : Sql dba

1 Answers  


What are indexes, and what are the different types?

3 Answers  


Why we use cross join?

1 Answers  


what is check constraint? : Sql dba

1 Answers  


How many LONG columns are allowed in a table?

6 Answers   CTS,


How to find the count of letter "L" in HELLO

7 Answers   HP,


Give the structure of the function ?

2 Answers  


Categories