Popular Posts

  • SQL DELETE
    So far we’ve learnt how to select data from a database table and how to insert and update data into a database table. Now it’s time to learn...
  • SQL Training
    IT professionals and students from all over the world have many options for SQL training nowadays. They can learn SQL by going to instructo...
  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • SQL SELECT
    The SQL SELECT statement is used to select data from a SQL database table. This is usually the very first SQL command every SQL newbie learn...
  • SQL MAX
    The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column. The SQL MAX function syntax is very sim...
  • SQL JOIN
    The SQL JOIN clause is used whenever we have to select data from 2 or more tables. To be able to use SQL JOIN clause to extract data from 2 ...
  • SQL IN
    The SQL IN clause allows you to specify discrete values in your SQL WHERE search criteria. THE SQL IN syntax looks like this: SELECT Column1...
  • SQL LIKE
    We will use the Customers table to illustrate the SQL LIKE clause usage: FirstName LastName Email DOB Phone John Smith John.Smith@yaho...
  • SQL Tutorial
    SQL is short for Structured Query Language and is a widely used database language, providing means of data manipulation (store, retrieve, up...
  • SQL WHERE
    The SQL WHERE clause is used to select data conditionally, by adding it to already existing SQL SELECT query. We are going to use the Custom...

Wednesday, March 18, 2009

What is SQL Server?

Microsoft SQL Server
SQL Server is one of the most popular and advanced database systems currently available. SQL Server is provided by Microsoft.

Microsoft SQL Server is sometimes called as "Sequel Server". It can be managed using Structured Query Language.

While MS Access is meant for small applications, SQL Server supports large applications with millions of users or huge databases. SQL Server is much more powerful than Access and provides several other advanced features and much better security. SQL Server is compatible with MS Access. You can easily import/export data between these two.

SQL Server is a Relational database where data is stored and retrieved very efficiently.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)