Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_newbie
Starting Member
2 Posts |
 Posted - 2007-03-02 : 16:30:03
|
Hi everybody!This is my problem: I am having sql classes in a very incomplete way, i think... we are learning the sql syntax, all those commands... but I don't think I know what sql is... please feel free to insult me, as long as you answer my questions (I'll try to make them so they can be answered with simple yes/no's).1. What is exactly sql? -Is it a programming language or just commands for an existing sql server?2. Is oracle some kind of microsoft sql server and vice-versa? -Like visual studio and bloodshed dev c++ are c compilers?3. Is an sql server some sort of "host" for an sql application?Like dll vst's need hosts to run?4. An then? Is it supposed to allow us to build an application that IS a database? Like, code the scripts and interface (using some other language for the graphical interface), put it in your pen or something, give it to someone that doesn't know a thing about programming and say: "Here's your damn database app, put it on a folder, run the program and start adding stuff to the fields. If you want to make a backup the database file is named database.dat and it's inside the program's folder."Thanks in advance.  |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-02 : 16:39:34
|
| 1) SQL - Structured Query Language2) Yes. They are both DBMS (Database Management Systems)3) Yes and No. A database can have Stored Procedures. They are sort of a program to manipulate the data in the database.4) No. The database holds the data for the application (front end).Yes, if you are using MS Access.5) There are many database management systems. It seems you have a propriatary DBMS.Peter LarssonHelsingborg, Sweden |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-02 : 16:40:37
|
| 1. T-SQL is the language that SQL Server uses2. Oracle is a database management system. SQL Server server is a database management system. They are made by different vendors.3. SQL Server is the engine and would have your database that your application will connect to get data. It's got nothing to do with dlls.4. SQL Server does not allow you to build an application. You would still need a front-end written. Tara Kizer |
|
|
|
sql_newbie
Starting Member
2 Posts |
Posted - 2007-03-02 : 18:13:49
|
| Hum... ok, so I must set up the server and tell the application how to access it, that's it?And if I create a server, I can go to the command prompt and do all that I want thru it?Are the databases like directories in the server? Can I create several databases in one server?Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-02 : 18:22:23
|
| In your connection string in your application, you would specify the connection parameters to the SQL Server. Yes you can run queries at the command prompt (for 2005, you would use sqlcmd), but you may prefer a GUI such as what SQL Server Management Studio offers, since you are so new to SQL.Databases are not like directories. It is way more complex than that. Yes you can create several databases on one instance of SQL Server.Tara Kizer |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-03-03 : 05:15:45
|
| directories... yes that's one way of looking at it, each database is like organizing the data in the server depending on how you define these 'directories'--------------------keeping it simple... |
|
|
|
|
|
|
|
|
Question that I am ashamed to ask personally