Popular Posts

  • SQL GROUP BY
    The SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certai...
  • SQL Hosting
    SQL Hosting is a web hosting plan featuring one or more SQL databases. Having SQL database backend is essential for most of the modern websi...
  • JSP Scripting Elements
    JSP scripting elements let you insert Java code into the servlet that will be generated from the current JSP page. There are three forms: ...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • The JSP page Directive
    The page directive lets you define one or more of the following case-sensitive attributes: * import="package.class" or import=...
  • SQL Replication
    SQL Replication term describes a group of technologies allowing information distribution and mirroring between different databases. SQL repl...
  • JSP ARCHITECTURE
    JSP pages are high level extension of servlet and it enable the developers to embed java code in html pages. JSP files are finally compiled ...
  • SQL Server 2005 Express
    SQL Server Express is a free, easy to use, redistributable version of SQL Server 2005 designed for building simple data-driven applications....
  • SQL SELECT INTO
    The SQL SELECT INTO statement is used to select data from a SQL database table and to insert it to a different table at the same time. The g...
  • SQL AND & OR
    The SQL AND clause is used when you want to specify more than one condition in your SQL WHERE clause, and at the same time you want all con...

Wednesday, March 18, 2009

SQL Management Studio Editions

SQL Management Studio comes in two flavours:

1. SQL Management Studio

This edition comes with all versions of SQL Server 2005 except SQL Server 2005 Express Edition. This edition has various advanced features like import data from other database systems, export data to other databases etc.

2. SQL Management Studio Express

SQL Management Studio Express is part of SQL Server 2005 Express Advanced edition. You can download Management Studio Express as a separate tool also. Some of the key features like Import data, export data etc are missing in the Express edition of Management Studio.

For learning purposes and development purposes, the express edition serves the purpose. After all, it is FREE !

The non express edition of the management studio is also free when you purchase non express editions of SQL Server 2005, but you have to pay several thousand dollars for the SQL Server license.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)