How I can do a row ID in SQL Server

5 pts.
Tags:
Oracle
SQL Query
SQL Server
Hi, excuse me, I want to do some ask for you. How I can do a row ID in SQL Server because I need a row ID CE517DED-7A39-48B0-85BD-73B95018FACB. Because in Oracle I know than this is possible, but in SQL Server, I don't know. I hope you can help me please.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

When creating the table add a column and make it an identity

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    What exactly do you mean by "do a row ID"?

    Since you mentioned Oracle, how would you do it in Oracle? (this could help clarify what you mean, since you do not do rowids in Oracle).

    PS - Your example looks more like a GUID.
    84,670 pointsBadges:
    report
  • FrancoTeamate
    use ROW_NUMBER() OVER ()
    as select column 

    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: