I'm using sql 2005

Do you by chance know how to access those objects in 2005?

Andy DBA (1/11/2007)

CORRECTION. The prior posted sql may have duplicates. The following should work better:

--List tables, columns and column descriptions

select SO.name as 'table', SC.name as field,

ST.name as...

Since this constraint isn't required, but more of something that I'd like to have, I'll probably pass on it. It'll probably needlessly complicate things.

But on the other side of the...

anyone?

I keep reading in places that it can be done via functions/views or something, but I'm not sure how to do this

Anyone know?

Kris

Could someone give me some pointers?

if I had the two tables

PK User

1 Bob

2 Jim

3 Tom

Fk Role

1 ...

It looks Like the 'Keep Together' works if you set up the table layout differently

Header

Group 1

Detail 1

Detail 2

Group 2

Detail 1

Detail 2

Group 3

Detail 1

Detail 2

Group 4

Detail 1

Detail 2

Page 2

Header

Group 1

Detail 1

Detail...

After doing some testing, maybe I'm going about this the wrong way.

I have a asp.net web site, I need to provide reports to my users concerning the data they've entered...

So you'd normalize each of the favorite fields into its own table

suppose you had this form on a web page

Name: Bob

Gender: 38

Age: 38

Favorite Food: food1, food2, food3

Favorite Town: town1,...

I wanted to add that I understand that csv fields tend to lessen the power of a relational database.

One of the things I've been pondering is turning the three fields...