Newbie basic questions

Re: Newbie basic questions

Kryten (Kryten68@googl email.com) writes:

I'm only going to need at most 12 tables, each with no more than 50
records and 6 fields. Can this be set up visually in SQL, like in MS
Access?

You can do database diagrams in SQL Server Management Studio, but it's
quite much of a toy feature. It's seriously broken when it comes to changing
existing tables. Then again, it's probably designed for small-scale
databases like yours, so you should be fine.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hi,
I'm developing some Powershell applications that will need to pull
data out of some sort of container.
I've been playing around and had some success getting this working
with MS Access. But for various I'm keen to explore other options for
this database.

I'm only going to need at most 12 tables, each with no more than 50
records and 6 fields. Can this be set up visually in SQL, like in MS
Access?

What would I need to get started with this?

If so, what would be the best book to buy to cover the basics?

Thanks,
Stuart