July 14, 2011 at 7:04 am
If I wrote an application to use ADO or DAO recordsets, can this database be read using SQLServer?
Is SQL the actual database or the language to get data from the database?
In order to work with SQL database, must all the SQL Server xxx services be running on the client / development machines?
Thanks,
marinaa
----------------------------------------------------------------------------------------------------
July 14, 2011 at 7:09 am
T-SQL (Transact SQL) is the language Microsoft SQL Server uses to get data into and out of the database. The database itself is just binary files managed by SQL Server, which is the database engine.
PL/SQL is the Oracle version of the SQL language. The database is, again, just some binary files on a hard drive. The engine in that case is Oracle.
Does it help to know that "SQL" stands for "Structured Query Language"? Does that answer the question about whether it's a language or something else?
SQL Server, on the other hand, is a Microsoft database product that uses T-SQL.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 14, 2011 at 7:10 am
fastformation01 (7/14/2011)
If I wrote an application to use ADO or DAO recordsets, can this database be read using SQLServer?
Generally, it is the other way around. The data resides in your SQL Server database; your application reads some data from the database into your ADO or DAO recordset.
Is SQL the actual database or the language to get data from the database?
SQL is an acronym for Structured Query Language. SQL is a set based language for querying/creating relational databases. There are many relational databases on the market like: MS SQL Server, MySQL, Oracle, ...
In order to work with SQL database, must all the SQL Server xxx services be running on the client / development machines?
It really depends upon your environment, but if your development database is on a separate server, then you wouldn't need SQL Server installed locally on your machine (SQL Server services).
HTH,
Rob
July 14, 2011 at 7:12 am
On the DAO/ADO recordsets, those are usually objects in an application. You can use those to read from SQL Server, not the other way around.
On the question about the services, no, you don't need any of them running on a client. Just your application, or your development environment (usually either SQL Server Management Studio or Business Intelligence Development Studio or Visual Studio, if you're using Microsoft products). The server needs the services, not the client.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply