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.
Popular Posts
-
Learning about Events Visual Basic is "Event Driven" language. What does it mean? Everything that happening, launch an event. You... -
Methods A Method is a procedure built into the class. They are a series of statements that are executed when called. Methods allow us to han... -
Input/Output with files C++ provides the following classes to perform output and input of characters to/from files: * ofstream: Stream c...
-
Working With Integers (Continue) Question: What will be printed on the form after executing the following code: Dim Blah As Integer Print Bl...
-
Getting Started Note that all the images in this tutorial taken from Visual Basic version 6.0. If you using other version of Visual Basic, t... -
SQL Server (and SQL Server Express) supports two authentication modes: 1. Windows Authentication mode 2. Mixed Mode (Windows Authentication ... -
Changing the button's Properties Now you have a button on your form. You can change its location by dragging it, and change its size by ... -
Friendship and inheritance Friend functions In principle, private and protected members of a class cannot be accessed from outside the same ... -
Conditional Statements If....Else statement If conditional expression is one of the most useful control structures which allows us to execut... -
Abstract Classes An abstract class is the one that is not used to create objects. An abstract class is designed to act as a base class (to b...
No comments:
Post a Comment