开发问题：oracle，sql server等 [英] developpement questions: oracle,sql server etc.

问题描述

大家好，我对sql有一些疑问：

1.我之前使用的是sql server 2008，sql server 2008是db语言吗？而develep工具被称为sql server management studio？这是关系吗？如果有，请确保这一点，谢谢



2.i现在使用oracle作为db，oracle是开发语言？并且为了使用它，我们必须安装工具sql developer？而工具oracle通用安装程序是什么？什么是sql和什么是pl-sql？ pl-sql只适用于oracle？和Transal-sql只适用于sql server？感谢任何有用的回复！

解决方案

SQL是一种语言（结构化查询语言），用于查询关系数据库（RDBMS）。



所有简单查询都可以用标准化语言的版本表示。最常用的标准是使用可能是SQL-89。大多数RDBMS都兼容SQL-89;然而，大多数RDBMS还添加了标准未解决的额外功能，因此提供商使用专有扩展扩展语言。



Microsoft使用称为T的SQL风格-SQL（事务SQL）

其他像MySQL，Sqlite，Oracle也有扩展。



大多数RDBMS作为服务运行，即，它们在服务器上运行，需要软件来执行查询。该软件可以是命令行界面，您提到的GUI工具，或使用数据库API的其他软件。

SQL Server 2008（或MsSql）不是语言 - 它是 支持 SQL语言方言的应用程序。您可以使用SQL语言通过SqlConnection和SqlCommand对象告诉SQL Server要执行的操作以及执行此操作的数据库。

SQL Sever Management Studio（或SSMS）是一个应用程序它随MsSql一起提供，允许您创建，删除和修改数据库和用户，以及配置MsSql的工作方式。它不是一个严格意义上的开发工具，因为它不容易生成可以提供给用户的代码，并期望它们能够与您的数据库一起工作 - 扩散SMSS不是一个好主意，因为它给出了太多，太多控制普通用户：它是一个数据库管理员工具。



Oracle与MySql相同，相当于MsSql;对于你的其他问题，我建议你从谷歌开始，并按照一些链接 - 听起来你需要学习很多东西！

奇怪的问题。让我们看看：

< il>没有。 SQL Management Studio只是一个很好的管理工具：

http://en.wikipedia.org/ wiki / SQL_Server_Management_Studio [ ^ ]。



这只是一个应用程序。它不能是一个开发工具。充其量，这是重要的工具之一，而不是主要工具。请参阅：

http://en.wikipedia.org/wiki/SQL_Server_Management_Studio [< a href =http://en.wikipedia.org/wiki/SQL_Server_Management_Studiotarget =_ blanktitle =New Window> ^ ]，

http://microsoft.com/sqlserver [ ^ ]。






1. 作为一种语言，没有Oracle这样的东西。语言是SQL：
   
   http://en.wikipedia.org/wiki/SQL [ ^ ]。
   
   
   
   同时，我不会将SQL称为开发语言。最终，当涉及到即用型应用程序时，您无法仅使用SQL来开发它们。 SQL是一种声明性语言，它不会生成任何应用程序。您已经在标签中提到了ASP.NET。这意味着您需要使用C＃，VB.NET和/或其他.NET语言进行开发。请参阅下面的内容。

开发ASP.NET应用程序真正需要的是ADO.NET。不是语言（语言可以是任何.NET语言）。一个库，包含适用于不同RDBMS的适配器类。请参阅：

http://en.wikipedia.org/wiki/ADO.NET [ ^ ]，

http://msdn2.microsoft.com/en-us/library/aa286484.aspx [ ^ ]。



这是一篇简短而清晰的CodeProject文章，它可以帮助您立即开始：为初学者使用ADO.NET [ ^ ]。



祝你好运。

- SA

hi guys, i have some questions about sql:
1. i've use sql server 2008 before, and sql server 2008 is a db language? and the develep tool is called "sql server management studio"? is this the relation? if yes, please make sure of that, thanks

2.i now use oracle as the db, oracle is the developpement language? and for using it, we must install the tool "sql developer"? and the tool "oracle universal installer" is what? what's sql and what's pl-sql? pl-sql is just for oracle? and Transal-sql is just for sql server? thanks for any helpful replies!

解决方案

SQL is a language (structured query language) that is used to query relational databases (RDBMS).

All simple queries can be expressed in a version of the language that was standardized. The most commonly used standard is use is probably SQL-89. Most RDBMSs are SQL-89 compatible; however most RDBMSs also add extra functionality that is not addressed by the standard, so providers "extend" the language with proprietary extensions.

Microsoft uses a flavour of SQL called T-SQL (Transaction SQL)
Others like MySQL, Sqlite, Oracle also have extensions.

Most RDBMSs operate as a service, that is, they run on a server and require software to perform queries. This software may be a command-line interface, a GUI tool like the ones you mentioned, or other software that uses the database's API.

"SQL Server 2008" (or "MsSql") is not a language - it is an application that supports a dialect of the SQL language. You use the SQL language to tell SQL Server what to do, and which database to do it with, via SqlConnection and SqlCommand objects among others.
SQL Sever Management Studio (or "SSMS") is an application which ships with MsSql and allows you to create, deleted and modify databases and users, as well as configure how MsSql works. It's not strictly a development tool, in that it doesn't easily produce code that you can give to a user and expect them to be able to work with your database - proliferating SMSS is not a good idea as it gives far, far too much control for the "average" user: it's a Database Administrators tool.

Oracle is an equivalent of MsSql in the same way as MySql is; for the rest of your questions I suggest you start with Google and follow a few links - it sounds like you have a lot to learn!

Strange questions. Let's see:

<il>No. SQL Management Studio is only a, well… management tool:
http://en.wikipedia.org/wiki/SQL_Server_Management_Studio[^].

This is just one application. It cannot be a development tool. At best, this is one of the important tools, not the main one. Please see:
http://en.wikipedia.org/wiki/SQL_Server_Management_Studio[^],
http://microsoft.com/sqlserver[^].



1. There is no such thing as Oracle, as a language. The language is SQL:
   http://en.wikipedia.org/wiki/SQL[^].
   
   At the same time, I would not call SQL a "development language". Ultimately, when it comes to ready-to-use applications, you just cannot develop them with just the SQL. SQL is a declarative language, it does not make any applications. You already mention ASP.NET in your tags. It means you will need to develop in C#, VB.NET and/or other .NET languages. Please see below.

What you will really need to develop ASP.NET application is ADO.NET. Not a language (the languages would be any .NET languages). A library, complete with the adapter classes for different RDBMS. Please see:
http://en.wikipedia.org/wiki/ADO.NET[^],
http://msdn2.microsoft.com/en-us/library/aa286484.aspx[^].

This is a short and clear CodeProject article which can help you to get started in no time: Using ADO.NET for beginners[^].

Good luck.

—SA

这篇关于开发问题：oracle，sql server等的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！