i just installed sql server 2008 express in order to learn microsoft sql.
why should i install sql management studio express? is it much easier to use this GUI?
i just installed sql server 2008 express in order to learn microsoft sql.
why should i install sql management studio express? is it much easier to use this GUI?
If you installed SQL Server 2008 Express and got a GUI, that is the SQL Management Studio Express which was included in the installation.
They have a seperate installation fo the Management Studio Express, which will install just the client GUI without the database server, in case you want to use it to connect to a SQL Server database running on another machine.
The default GUI for SQL Server is Management Studio, so you should already have it. If not, it is a free download here.
It gives you visual access to tables, stored procedure and many of the other features of SQL Server. Not to mention a nice SQL editor with syntax highlighting which also works as a SQL console.