MySQL和SQL Server之间的差异 [英] Differences between MySQL and SQL Server

问题描述

我是一个 ASP.NET 开发人员，他对所有计算机都使用了Microsoft SQL Server我的数据库需求(在工作中和个人项目中都需要).

I'm an ASP.NET developer who has used Microsoft SQL Server for all my database needs (both at work and for personal projects).

我正在考虑为我的一些个人项目尝试使用 LAMP 堆栈.

I am considering trying out the LAMP stack for some of my personal projects.

MySQL和SQL Server之间的主要区别是什么?在MySQL中，是否使用存储过程?

What are some of the main differences between MySQL and SQL Server? Is using stored procedures a common practice in MySQL?

您有什么建议或资源可以帮助我进行转换吗?

Any advice or resources you'd recommend to help me with the switch?

对于同时拥有这两种经验的人来说，MySQL是否缺少任何功能?

To those who have experience with both, are there any missing features from MySQL?

推荐答案

您需要注意的一件事是，SQL Server和MySQL实现SQL语法的方式存在相当大的差异.

One thing you have to watch out for is the fairly severe differences in the way SQL Server and MySQL implement the SQL syntax.

这是一个很好的不同SQL实现的比较.

例如，看一下top-n部分.在MySQL中:

For example, take a look at the top-n section. In MySQL:

SELECT age
FROM person
ORDER BY age ASC
LIMIT 1 OFFSET 2

在SQL Server(T-SQL)中:

In SQL Server (T-SQL):

SELECT TOP 3 WITH TIES *
FROM person
ORDER BY age ASC

这篇关于MySQL和SQL Server之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！