GUID uses

[sakhi kul]

hi to all,

I want to ask about GUID. what is the main use of GUID in our database.
I have seen that many developers uses GUID in user table(contains username and password)
and they update GUID of that user each time when user login.
In asp.net I have created GUID using System.GUID.newGUID().

[dnanetwork]

i've used so far..

forgot password / email verification..

[sakhi kul]

will you tell me or guide me what is that so far.. uses...?

[dnanetwork]

well it depends on your database..
on creating user i add a column GUID and assign default value to column using
newid() function in sqlserver 2005/08..

start with scenario..
say i forgot my password..
i will ask user to give me the username
depend on that i will grab email address and guid..

now i will setup a link to my site which holds
the user's email address and Guid..
and send email to user..

when user cliks the link, it gets redirected to my site
so on page load i check if Guid and email matches correctly then
allow now user to change the password...

hope that helps !

[sknake]

SQL Server has a different type of GUID compared to what you would generate normally in C#. Take a look at this article:
http://sqlblogcasts.com/blogs/martinbell/archive/2009/05/25/GUID-Ordering-in-SQL-Server.aspx

If you're using a GUID primary key identifiers in a heavily upserted table it may behoove you to read that article.