how i can generate sequence number in sql server

Question

Post reply

how i can generate sequence number in sql server

kaushalkumar.thakur

SSC Enthusiast

Points: 102
More actions
May 9, 2008 at 4:36 am

#186308

suppose i hav employee name i want the sql command automatically genertae the distinct emp id....plz can any one help me ,wat will be the query for that

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

rajankjohn SSCertifiable Points: 5061 More actions · Answer 1

Please specify your table structure.

http://rajanjohn.blogspot.com

kaushalkumar.thakur SSC Enthusiast Points: 102 More actions · Answer 2

suppose i hav a table name as empdetail which has column as empname,empdesignation.I want to add a new column in this table as empid which will automatically generate by query when i insert name and designation in this table.

Anipaul SSC-Insane Points: 24681 More actions · Answer 3

Read these:

http://blogs.msdn.com/sqlcat/archive/2006/04/10/sql-server-sequence-number.aspx

http://www.eggheadcafe.com/community/aspnet/13/10018541/sql-server-sequence-numbe.aspx

http://www.sqljunkies.ddj.com/Article/4067A1B1-C31C-4EAF-86C3-80513451FC03.scuk

🙂

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 4

[font="Verdana"]Why don't you go then for Identity column? SQL Server will take care of it. For more information refere BOL.

Mahesh[/font]

MH-09-AM-8694

Jeff Moden SSC Guru Points: 1004329 More actions · Answer 5

I agree... adding an IDENTITY column to the table will take care of it.

And, Sequence tables are notorious for causing deadlocks in SQL Server because most folks don't write the code for them correctly.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)