Newbie Question: What is SQL Server?

[Bickyz]

All i know is SQL server is related to database? but what sql server really does?

 

[tran008]

well...are you familiar with MS-ACCESS? Think of SQL as MS-ACCESS on steriod.

 

[SQLSister]

SQL server is a full-featured relational database. As such it stores information in tables and uses various methods to insert, update, delete and select data. UNlike Accesss, it does not have a way to develop the user interface, so you must use some other program for that such as VB, C++ , VB.Net, C#, etc.

It is used for an of the things databases are typically used for: purchasing systems, accounting systems, help desk systems, back end for web sites, Any kind of business information system you would want. oOu can often buy packaged systems which use SQL Server as their backend or you can develop the database and front end yourself to your company's specific needs.

SQL Server is a Microsoft product and can only run on servers running a MIcrosoft operating system.

Questions about posting. See faq183-874

 

[Bickyz]

For example lets say ive a database of library in MS Excess as library.mdb file. Can i put this file in sql server so that all the users frm networked pc can access it.

 

[paul172]

There is a utility that will allow you to convert your ACCESS mdn file to allow the user to still use the access front end. The database will however be SQL and not Access.

I can't remember the name of it, maybe Bill knows!

 

[camy123]

SQL server is not the database. SQl server is merely a Engine which allows applications such as enterprise manager,QA profiler to create database applications.....etc.etc.etc...