Posted by Charlie on 08/05/07 23:10

Thanks. I've been writing SQL in Access for years (for what it's worth). It
may be more of a hindrance than an asset. I have installed Management Studio
Express, and like it so far.

I have two text books so far, but they are for SQL 2000.

Charlie

"Hugo Kornelis" <hugo@perFact.REMOVETHIS.info.INVALID> wrote in message
news:e8acb3pv8712ghcm5g4ingecfl9bje5muk@4ax.com...
> 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]