Computer Hope

Microsoft => Microsoft Windows => Windows XP => Topic started by: samp on December 29, 2009, 08:45:06 AM

Title: What is SQL ??
Post by: samp on December 29, 2009, 08:45:06 AM
Greetings,

I have an MSSQL icon on my taskbar and wonder what it does and is it necessary?  I tried looking it up but was dazzled by the jargon and still don't know in plain english what it is for.  Can anyone enlighten me on its purpose or necessity?

Many thanks (for now and all the excellent past help/advice I have received)

Samp
Title: Re: What is SQL ??
Post by: BC_Programmer on December 29, 2009, 08:51:16 AM
Databases.
Title: Re: What is SQL ??
Post by: Geek-9pm on December 29, 2009, 10:33:45 AM
You or someone has recently installed a program or component that needs the use of SQL.  For example, programs developed with current Microsoft Visual Studio tools.

There are various products with the SQL in the name. One would  expect them all to have something in common. Not exactly true.

Example, here is a very simple definition for SQL Windows
http://www.pcmag.com/encyclopedia_term/0,2542,t=SQL+Windows&i=51912,00.asp

Don't dare ask what I think of it.
Title: Re: What is SQL ??
Post by: BC_Programmer on December 29, 2009, 10:38:43 AM
You or someone has recently installed a program or component that needs the use of SQL.  For example, programs developed with current Microsoft Visual Studio tools.

Visual Studio 2005/2008 don't require SQL of any sort. threy do try to install SQL express, and they can use such things and LINQ combined with SQL to do some neat things, but they certainly don't require it.

SQL is "structured query language" and is really a generic term. SQL is used by Oracle, Access/Jet, the windows search service, and all sorts of other things; they are not the same, but they follow the same basic syntax rules.

But this is not the point, the question here is why their machine has any form of SQL installed. In this case, MSSQL, which is Microsoft SQL Server, possibly the express edition. If Visual Studio has been installed this is possibly how it got there.