sql query statement

Question

Hi All  How to convert string value into unique identifier value let say @fname= 'ram' i want to convert 'ram' into unique identifier

Vinay Singh · Answer

Hi You can generate against each name and store it in DB and while comparing just compare the guid of name. Guidg; /CreateanddisplaythevalueoftwoGUIDs. g=Guid.NewGuid(); Console.WriteLine(g); Console.WriteLine(Guid.NewGuid()); have a look of the link https://msdn.microsoft.com/en-us/library/system.guid.newguid%28v=vs.110%29.aspx http://www.c-sharpcorner.com/UploadFile/prasoonk/guids-in-C-Sharp-and-net/ Or you can do one thing also white storing the detail in DB just add one more column identity column. and store the value against the name.