SQL Server:与一般编程相比的 SQL 查询 [英] SQL Server: SQL queries compared to general programming

问题描述

我刚刚开始使用 SQL Server 2008 Express，并在最后一个小时左右尝试了一些基本查询.SQL 脚本(正确术语?)与一般计算机编程相比如何?编写 SQL 查询是否与软件开发一样涉及、学习时间长、需要大量练习等?至少在某种程度上，编写高级 SQL 查询与软件开发是否具有可比性?如果是，您能解释一下吗?

I'm just starting out with SQL Server 2008 Express and spent the last hour or so trying out some basic queries. How does SQL scripting (correct term?) compare to general computer programming? Is writing SQL queries as involved, lengthy to learn, needs as much practice, etc. as software development? Is writing advanced SQL queries comparable to software development, at least to some degree, and if so could you explain that?

另外，我找到了一些用于学习 SQL 的教程和参考网站，但您能否推荐一些其他网站.

Also, I found a couple of tutorial and reference sites for learning SQL but could you also recommend some other sites.

另外(2)，我在 SQL Server 中使用 SQL 查询设计器，它似乎是学习编写 SQL 命令的好工具，但有没有办法使用设计器插入数据.似乎它只用于 SELECT ing 数据.

Also(2), I was playing around with the SQL query designer in SQL Server and it seems like a good tool to learn writing SQL commands, but is there a way to use the designer to INSERT data. it seems that it's only for SELECT ing data.

任何其他关于学习、更好理解等 SQL 的一般性评论将不胜感激.谢谢

Any other general comments for learning, better understanding, etc SQL would be appreciated. thanks

推荐答案

SQL 是一种声明性语言，主要处理集合.

SQL is a declarative language and it primarily deals with sets.

因此它与过程语言非常不同.

As such it it very different from procedural languages.

我认为它介于过程语言和函数式语言在风格方面.

I would say it is somewhere between procedural languages and functional languages in terms of style.

我会推荐 Joe Celko 的书，这是 Hernandez，这个来自 Bowman.

I would recommend Joe Celko's books, this one by Hernandez, and this one by Bowman.

在 SSMS 中，您可以将数据粘贴到表格中(通常来自 Excel).

In SSMS, you can paste data into a table (usually from Excel).

通常没有用户通过 SSMS 输入数据，通常使用 SSIS 之类的工具加载数据.

Typically no users enter data through SSMS, usually loading data using a tool like SSIS.

可以使用 INSERT INTO tbl VALUES (x, y, z) 插入数据，SQL Server 2008 通过行构造函数具有多行插入能力: INSERT INTO tbl VALUES (x, y, z), (a,b, c)

You can INSERT data using INSERT INTO tbl VALUES (x, y, z), and SQL Server 2008 has a multi-row insertion ability through row constructors: INSERT INTO tbl VALUES (x, y, z), (a, b, c)

这篇关于SQL Server:与一般编程相比的 SQL 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！