Posted by Hugo Kornelis on 08/05/07 19:49

On Sat, 4 Aug 2007 15:30:02 -0400, Charlie wrote:

>I have the free version. What advantage is the developer version over the
>free version? I am having trouble creating table relationships in the free
>version. Any advice?

Hi Charlie,

WRT relationships, the Express Edtion has the same features as any of
the other editions.

In case you haven't yet done so, you might want to download and install
Management Studio Express, a graphical interface exposing many of SQL
Server Express' features. For some, using a GUI is great. For many other
features, I wouldn't want to touch a GUI with a 10' pole, since writing
straight SQL gives me so much more control.

Using a GUI and then checking the generated SQL *can* be a way to learn
writing SQL, but beware that it's also a great to to learn to write bad
SQL, as some of the stuff that the GUI generates is terrible. You might
be better off buying (or borrowing) and reading a text book to write to
learn SQL.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

[Back to original message]