Topic: SQL Servers
Vietscouty's photo
Wed 11/18/09 06:09 PM
Can anyone in here tell me what the hell is a SQL Server? I've looked it up on the net to find more info about it but it doesn't seem to explain it to me in depth. I know what Window Server 2003 and 2008 is but what's really SQL? Thanks.

no photo
Fri 11/20/09 01:40 AM

Can anyone in here tell me what the hell is a SQL Server? I've looked it up on the net to find more info about it but it doesn't seem to explain it to me in depth. I know what Window Server 2003 and 2008 is but what's really SQL? Thanks.

Sql is a database software that runs on Microsoft Servers...
Oracle, is a Unix database, and OpenSQL is an open source database that runs on Linux and Windows...

Check out:
http://en.wikipedia.org/wiki/SQL

no photo
Tue 11/24/09 12:12 AM
Edited by darkstar83 on Tue 11/24/09 12:12 AM
sql = structured query language used to run queries to retrieve data

for instance you want everything from a table called "user"
sql query is:
select * from user;

if you want to try it out. get uniform server and sqlyog. both are free. just start uniform server first then sqlyog then run a couple of queries.

microsoft sql server is the same as sqlyog but some key words are different.

say:
in microsoft sql server: you are selecting top 1 row.
- select top 1 nameofcolumn from user;
in sqlyog
-select nameofcolumn from user limit 1;

no photo
Sun 11/29/09 10:30 AM

Can anyone in here tell me what the hell is a SQL Server? I've looked it up on the net to find more info about it but it doesn't seem to explain it to me in depth. I know what Window Server 2003 and 2008 is but what's really SQL? Thanks.


The following link may help:

http://www.microsoft.com/sqlserver/2008/en/us/learning.aspx

AndrewAV's photo
Tue 12/01/09 12:13 PM
SQL Server has become a common way to describe a database system. As stated before, SQL is the structure of how data in a database is retreived. SQL statements are commands given either at the datatbase command prompt or from other sources like websites to view/retreive data.

If you want to play around with one, mysql is free, but you'd better have an idea what you are doing with your system so you don't screw anything up.