how can impliment the auto increment id in an application by using the stored procedure in connected or disconnected approach in asp.net

Question

0.00/5 (No votes)

See more:

I want to increament id_no automatically.i have enabled its autoincrement id in server 2005 but i have no idea about its related query used in stored procedure.so that i can insert my all recored corresspondence to autoincrement id.........

Posted 22-Nov-11 22:07pm

zdeep_gill

Updated 22-Nov-11 22:21pm

Mehdi Gholam

v2

Add a Solution

2 solutions

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)

Mehdi Gholam · Answer 1 · 2011-11-22T22:22:00

Solution 1

You don't need to do anything except not insert the ID column when importing your data, the server will generate a ID column for you.

Posted 22-Nov-11 22:22pm

Mehdi Gholam

Pandya Anil · Answer 2 · 2011-11-22T22:25:00

The auto Increment is not for perticular query or stored procedure, the ID_NO column will be incremented automatically for all the inserts,

whatever the way you insert a record in the table. say through, direct query, from stored procedures or from triggers, the ID column will Increment by the value you have set.