Popular Posts

  • Data Adapter Connection Wizard
    Data Adapter Configuration Wizard In this section we will create our own data adapter, a built-in feature that comes with Visual Basic .NET ...
  • 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...
  • SQL Tutorial
    SQL is short for Structured Query Language and is a widely used database language, providing means of data manipulation (store, retrieve, up...
  • Write Your First Visual Basic Program
    What Is Visual Basic and Why do I need it? Visual Basic is Easy to learn Programming language. With Visual Basic you can develop Windows bas...
  • Other Data Types
    Defined data types (typedef) C++ allows the definition of our own types based on other existing data types. We can do this using the keyword...
  • 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...
  • Exercise 9.5: Pass By Reference
    Introduction: In this exercise, you will exercise the concept of pass by reference. Please not that primitive type parameters are passed ...
  • SQL INSERT INTO
    The SQL INSERT INTO syntax has 2 main forms and the result of either of them is adding a new row into the database table. The first syntax f...
  • Learning about Variables
    Learning about Variables Using Variables is one of the most basic and important subjects in programming, so this lesson is very important. V...
  • 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)