developpement questions: oracle,sql server etc.

Question

1.00/5 (1 vote)

See more:

, +

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!

Posted 17-Sep-13 3:28am

v03051435

Add a Solution

3 solutions

Solution 2

"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!

Posted 17-Sep-13 3:41am

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Yvan Rodrigues · Accepted Answer · 2013-09-17T03:38:00

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.

Sergey Alexandrovich Kryukov · Accepted Answer · 2013-09-17T03:49:00

Strange questions. Let's see:

http://en.wikipedia.org/wiki/SQL_Server_Management_Studio

^

http://en.wikipedia.org/wiki/SQL_Server_Management_Studio

^

http://microsoft.com/sqlserver

^

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

developpement questions: oracle,sql server etc.

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0