How to create a unique ID for a view on a table I can't alter
Posted on 2009-07-10
I am working with a database that I cannot alter. I'm using a view that I created in another database on the same server to query data from it. Within the view one of the tables has two fields that could act as a composite key, but no constraint is defined in the actual table.
I need to have a unique ID available for the application that I am using the view with. It is my understanding that within the view I am unable to assign a constraint.
Does anybody know of a way in which I can create a unique ID to use within the application that doesn't require making a change to the database I'm not allowed to alter?