what is a SQL server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using access for the first time now and they ask me to put in a SQL
server I have no idea what that is
 
hi
It is a special Database server which runs SQL(Structured
Query Language) SQL is a computer language developed by
microsoft. The SQL server's primary function (but not
limited to) is to manage Databases that use a front
end/back end set up.
The SQL server would house the database Tables and data
and it might be managed by the IT dept. all other users
would access and/or update the SQL server from remote PCs.
This is all vaque and general info about SQL servers.
Developed as a database server, they have been used in
other ways.
Regards
Frank
 
aviw00 said:
I am using access for the first time now and they ask me to put in a SQL
server I have no idea what that is
Click to expand...


You're kidding, right? Perhaps you should confess your ignorance and tell
them you have no idea what they're talking about. Tell them they might as
well ask the pizza delivery boy to set up the database.
 
Frank Stone said:
hi
It is a special Database server which runs SQL(Structured
Query Language) SQL is a computer language developed by
microsoft. The SQL server's primary function (but not
limited to) is to manage Databases that use a front
end/back end set up.
The SQL server would house the database Tables and data
and it might be managed by the IT dept. all other users
would access and/or update the SQL server from remote PCs.
This is all vaque and general info about SQL servers.
Developed as a database server, they have been used in
other ways.
Regards
Frank
Click to expand...


A minor quibble. SQL was not developed by Microsoft. SQL is an ISO/ANSI
standard language derived from SEQUEL (Structured English Query Language)
which was created by E.F. Codd, an IBM research fellow, back before
Microsoft was founded. As Frank has indicated, SQL Server is a RDBMS
product produced and marketed by Microsoft.
 
Quibbles are such fun, eh? Here's another one....

I just finished reading a chapter in "Go To", by Steve Lohr, a history of
programming, in which he ascribes the creation of SEQUEL to Don Chamberlin
and Ray Boyce of IBM. Not to minimize the role played by Codd, by the way!
<g>

Cheers!
Fred Boer
 
I could swear that I'd read that Codd outlined SEQUEL in his original paper.
It was further developed in "Project R" at IBM. I can't find anything to
support that, however. Thanks for the correction.

Randy
 
Microsoft Access gives you the option to either create a new Database (which
is 100% Access/Jet) or create a new Project (Access as a user interface
(front end) to an SQL Server data file (back end)).

It sounds like you are trying to "Create a new Project". *Don't* do that if
you aren't using SQL Server. You want to "Create a new Database" (no SQL
Server prompt).

HTH,
 
Back
Top