Inserting an identity column in view

[davideart]

Hi all..that's my problem and i really hope some of you can help me.

I have to create a view selecting all fields from a table; plus, i'd like to insert an addictional column defined as an identity (or a random numeric value) so that i can create a sort of unique field for that view.
To explain better, I'd need something like:

select *, getdate() from table

but, instead of getdate() function, I'd need a function that insert unique numeric values (random or sequential indifferently)

Has any of you an idea?
Thank you in advance, bye
David

 

[JamesLean]

You could use this which gives a GUID value:

CREATE VIEW myview
AS

SELECT NEWID() AS pk, *
FROM mytable

--James

 

[davideart]

Hi James...thank you very much: the NEWID() function is more or less what i was looking for.

Thank you again for quick and precise reply, cheers!

David