How to generate userid in SQL

Question

1.00/5 (2 votes)

See more:

Declare @UID varchar(30)
Set @UID=@UserId
Set @UID= @UserId
SET @UserId = @UID+1;

INSERT INTO Tbl_Anti_Ragging2(UserId,CollegeId,Year,Duration,authoritites_Name,authoritites_Designation,authoritites_Contact)
VALUES(@UserId,@CollegeId,@Year,@Duration,@authoritites_Name,@authoritites_Designation,@authoritites_Contact)

i am sending multiple row at one time from my C# code and i want to insert when First save butoon then value save like 1
1
1
1
second time 2
2
2
2

What I have tried:

Above is my Query -

i am inserting value i want to know how to insert means query execute then

Userid make like 1
1
1
1
and when query second time execute then i will do userid +1 like-

2
2
2
2
so Please help me--

Posted 31-Mar-17 23:34pm

Member 12183079

Updated 2-Apr-17 3:19am

Add a Solution

Comments

[no name] 1-Apr-17 8:01am

Use an identity column.

Member 12183079 1-Apr-17 8:15am

No i am sending multiple textbox value on submit button and i want to make on submit button row create 1 and next time on submit button row create 2

[no name] 1-Apr-17 14:06pm

Well if you want to do it wrong then go ahead.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2017-04-02T03:19:00

As @NotPoliticallyCorrect has already said, the correct way to do this is to use an Identity column. At the very least do not refer to this column as an ID - unless this is just a means of generating data and the UserId column on this table is actually a foreign key to another table.

You could just increment a number within your C# code - it would have to be a class-level ("global") variable. This is not a good design however - it assumes that this program will only ever be run as this instance by one user and once finished will not be needed again.

You could do this instead...

SQL

CREATE TABLE GenerateIDs
(
	NextId int identity(1,1),
	requestBy nvarchar(125)
)

If you create a Stored Procedure to update this table

SQL

CREATE PROCEDURE [dbo].GetId @who nvarchar(125)
AS
	INSERT INTO GenerateIDs VALUES(@who) 
	SELECT SCOPE_IDENTITY()

Then each time you want to increment that number run the Stored Procedure first to get the Id number to use.