I don't really think this will help very much.

But a clean structured FAQ section surely will

See if this helps: http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

The final question however, is why you need a rownum stored in a table?

Actually I think the most important question.

One might be inclined...

BOL and http://www.sqlservercentral.com/columnists/chedgate/clusterthatindex.asp

http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexparttwo.asp

http://www.sqlservercentral.com/columnists/chedgate/clusterthatindexpart2.asp

is a good start.

The "main" difference is to understand, that a clustered index is actually the data, while a nonclustered index is a separate...

http://www.sybase.com/products/informationmanagement#ds

I think you can download SQL Anywhere for free.

And though I can't say, whether Sybase has a future, it's always good to know more than one product.

It's stored as favorite. Just because it is that frequently needed.

...no-one searches before posting...

Sad, but true.

Just out of curiosity, don't you think this is nothing but a presentational issue and an easy task for any client app?

A lot of things in life are easier when all your tables have a PRIMARY KEY.

Anyway, see if this helps: http://support.microsoft.com/default.aspx?scid=kb;en-us;186133

But I...

http://www.sommarskog.se/arrays-in-sql.html

Another one:

http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx?Pending=true

My understanding is that a PRIMARY KEY in SQL Server does never allow duplicates and no NULLs. When you read BOL at CREATE INDEX about IGNORE_DUP_KEY, you'll see it talks about...

Result would be the same, as MIN() is not needed

I guess you can understand, that online communities can be a drug...

Can you also set-up PRIMARY KEY to IGNORE DUPLICATE:  YES

AJ, are you sure on this???

If you have a unique column, this is also possible in SQL Server. And no, what I meant is that NOT EXISTS checks whether the keycolumn already exists in the...