Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

CSharp TV
Videos
Tech
Articles
Blogs
News
Forums
Books
Events

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Latest Forum Questions

Error converting data type nvarchar to numeric
David Godistei42m ago2
winform task
Nandini Sonawane9h ago1
Repair MS Outlook PST file issue
Chemline Dorno2d ago2
CrystalDecisions.CrystalReports.Engine
Ramco Ramco4d ago0
How to load 5000 data in Power Apps gallery
Ismail Sayyad10d ago1
Which library is primarily used for numerical computing in Python?
tejasri10d ago1
Best pattern for streaming AI responses into a Blazor Server app without flooding the SignalR circuit?
Aarti Jangid11d ago0
How Can AI Data Engineering Improve Data Quality and RAG Application Performance?
Aarti Jangid12d ago0
How to Prevent Sensitive Data Exposure in AI Workflows
Rom C12d ago0
What is RAG in Generative AI?
tejasri16d ago4
add code snippet
Priya Prajapati18d ago2
about azure app service
jahnavi charakani19d ago0
How do you handle missing values in a dataset before building a machine learning model?
tejasri23d ago3
lock parent thread with message dialog in background thread
aron clark25d ago3
How to add rule root level web config
Pratik Dholu25d ago4
What is full-stack data science, and how is it different from traditional data science?
tejasri26d ago2
online test in asp.net core api and angular
Ndumiso Ngcobo27d ago1
Can Intent, Account Abstraction and DID Work Together in One Web3 Wallet?
elisha meenu27d ago1
Can I recover SQL Server database records along with the documents stored in them?
samaira27d ago1
Hide comment on article
Priya Prajapati27d ago2

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

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

Home
Forums

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

SWAROOP P

12yAsked May 14, 2014, 10:00 AM1.8k

How to create unique id in a table without using identity

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

sudipta sanyal12y ago
Accepted 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
0
SWAROOP P12y ago
I got one more answer from below link.

http://www.aspdotnet-suresh.com/2012/04/set-custom-auto-generatedincrement.html
0