How to create unique id in a table without using identity?

Question

How to create unique id in a table without using identity

sudipta sanyal · Answer

DECLARE @myid NVARCHAR(50) SET @myid = NEWID() PRINT 'Value of @myid is: '+ CONVERT(varchar(255) @myid) ------------------------------------------ CREATE TABLE #temp_table (eid NVARCHAR(100) DEFAULT newid() ename NVARCHAR(200)) INSERT into #temp_table (ename) VALUES ('SS') INSERT into #temp_table (ename) VALUES ('FDFF') SELECT * FROM #temp_table DROP TABLE #temp_table

SWAROOP P · Answer

I got one more answer from below link. http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html