Popular Posts

  • 4 Reusable Components and the FCL
    4 Reusable Components and the FCL Up to this point I have spoken quite a bit about the goals of the .NET Framework, as well as what it ...
  • 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...
  • INTERFACES EXAMPLES
    package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
  • 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...
  • 3 Visual Studio .NET
    3 Visual Studio .NET This section is a short one, but I cannot go on without mentioning Visual Studio .NET. Visual Studio .NET is not ...
  • Exercise 10.4: Packaging at the command line
    Please do this exercise at the command line instead of using NetBeans. This is to learn the concept of packaging without the help of NetBean...
  • CONTROL STRUCTURES
    CONTROL STRUCTURES: Three types of control structures: 1.Decision control structure : if,if else,nested if etc 2.Loop control structure ...
  • MouseMove, MouseDown and MouseUp Events
    MouseMove, MouseDown and MouseUp Events Lets check out the Command Button's MouseMove, MouseDown and MouseUp events. We will do that lik...
  • Exercise 9.6: Comparing Objects
    Introduction: In this exercise, you will exercise the concept of comparing objects using String class as an example. Steps to follow: 1. Wri...
  • Exercise 11.2: Inheritance - Overriding
    Steps to follow: 1. Modify Main.java as shown below in Code-11.2.a under personpackage directory. (You are welcome to do this work using ei...

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)