Answer / Hemendra Singh

Microsoft SQL Server and MySQL have several differences. Some of them include: Syntax variations, SQL Server being a proprietary database management system while MySQL is open-source, SQL Server supports Transact-SQL (T-SQL) as its query language while MySQL uses Structured Query Language (SQL), SQL Server offers more advanced features for business intelligence and reporting compared to MySQL.

What function does a database engine serve in the sql server?

1 Answers  

---

Explain what are magic tables in sql server?

1 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1 Answers  

---

What are the differences between clustered and non-clustered index?

1 Answers  

---

Can we install sql server 2016 on windows 7?

1 Answers  

---

Differentiate between mongodb vs. Sql server?

1 Answers  

---

What are the restrictions applicable while creating views? : SQL Server Architecture

1 Answers  

---

What is change data capture (cdc) in sql server 2008?

1 Answers  

---

What is difference between inner join and full join?

1 Answers  

---

What is the function of inner join?

1 Answers  

---

What is acid mean in sql server?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---