SQL Concept

Hello Experts,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11152-sql-concept.html

I appreciate this is not a SQL discussion group, but I always have the best
answers from here. So I thought I could try it here again.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11152

I have installed SQL Server 2005 in my local machine for testing and I
expected to be presented with some kind of user interface where I could
manage my tables etc.

So I my questions is:
Can anybody explain me (in plain English please) the following?
What’s SQL Server 2005 for?
What’s the purpose of installing SQL Server in a machine (or server) if,
apparently, doesn’t change anything. I say this because I have always been
able to write SQL queries in Access and it works OK (without the SQL Server
2005 installed).
How can I use its unknown, (for me), potential?
Would you have any website that I can research about better these concepts
of SQL?

Many Thanks
Fabio

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

SQL Server is a database. It stores the data.

Access is a both database and a development environment. You can create
forms and reports in Access: you can't in a database. The forms and reports
you create in Access can be used against tables in an Access database
(really a Jet database), or against databases from other DBMS, including SQL
Server.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11152


"Fabio" wrote in message
newsA7FDE58-CD54-40FA-97EC-EE35D3032400@microsoft.com...
> Hello Experts,
>
> I appreciate this is not a SQL discussion group, but I always have the
best
> answers from here. So I thought I could try it here again.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11152
>
> I have installed SQL Server 2005 in my local machine for testing and I
> expected to be presented with some kind of user interface where I could
> manage my tables etc.
>
> So I my questions is:
> Can anybody explain me (in plain English please) the following?
> What's SQL Server 2005 for?
> What's the purpose of installing SQL Server in a machine (or server) if,
> apparently, doesn't change anything. I say this because I have always been
> able to write SQL queries in Access and it works OK (without the SQL
Server
> 2005 installed).
> How can I use its unknown, (for me), potential?
> Would you have any website that I can research about better these concepts
> of SQL?
>
> Many Thanks
> Fabio

Here is all the stuff

http://www.microsoft.com/sql/prodinf...erver2005.mspx

Have fun reading (there is quite a bit)


--
Wayne
Manchester, England.



"Fabio" wrote:

> Hello Experts,
>
> I appreciate this is not a SQL discussion group, but I always have the best
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11152
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11152
> answers from here. So I thought I could try it here again.
>
> I have installed SQL Server 2005 in my local machine for testing and I
> expected to be presented with some kind of user interface where I could
> manage my tables etc.
>
> So I my questions is:
> Can anybody explain me (in plain English please) the following?
> What’s SQL Server 2005 for?
> What’s the purpose of installing SQL Server in a machine (or server) if,
> apparently, doesn’t change anything. I say this because I have always been
> able to write SQL queries in Access and it works OK (without the SQL Server
> 2005 installed).
> How can I use its unknown, (for me), potential?
> Would you have any website that I can research about better these concepts
> of SQL?
>
> Many Thanks
> Fabio