Sep 24, 2020 02:12 AM|Sean Fang|LINK
Could you please rephrase your problem?
Sorry that I am not sure what your purpose is. Do you want to involve GUID in your table?
If you directly use the modified sql query, obviously you will get an error message =>
Invalid object name 'GUID'.
Select * from GUID as mytable join GUID as mytable1 on mytable.NAME = mytable1.NAME
The correct way to use GUID in SQL server is to use NEWID() function
which will generate a value of type "uniqueidentifier".
Only if you specify the problem would we be able to target the problem and provide you with solutions.
Thank you for understanding.