Generate same id for one insert function call in sql server?

Question

0.00/5 (No votes)

See more:

i have insert list of values(itemname,session,date) example

aaa mrg 16/4/2013
bbb evng 14/4/2013
ccc dinner 15/4/2013

this values received,but how to insert these values with generate same id for these values in my sqlserver table?.for each insert query should call means,generate another id for list of values..advance thanks

i need this format...

1 aaa mrg 16/4/2013
1 bbb evng 14/4/2013
1 ccc dinner 15/4/2013

Posted 16-Apr-13 0:50am

sarathtamil

Add a Solution

Comments

PrashantSonewane 16-Apr-13 7:04am

You can do it multiple way. Like maintaining id in code side and passing it with every proc call. But if you are using SQLserver 2008, try using table value type to push whole list as param and insert into one go with one id. You need to learn more about how to use table value type, but i think its worthy.

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)

Praveen Kumar Chauhan (PRK) · Answer 1 · 2013-04-16T02:08:00

Solution 1

if you want to insert single value for each row for any column in table than use default keyword
ie

create table trail(id default(1),name varchar(50));

and if u want unique values for each row in table than use identity keyword

create table trail(id identity),name varchar(50));

Posted 16-Apr-13 2:08am

Praveen Kumar Chauhan (PRK)