Posted by Robert Klemme on 11/16/05 17:32

Sam wrote:
> Hi,
> In my stored procedure I'm doing a SELECT on
> INFORMATION_SCHEMA.TABLE_CONSTRAINTS. However there is no unique id on
> this table, so I was wondering if it was possible to add it
> dynamically in my SELECT, so that I would assign a unique id to each
> record returned by my SELECT?

Where do you need that for? Maybe this helps:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133

robert

[Back to original message]