i want to inert values to a table and return its primary key and a column value during insertion

Question

0.00/5 (No votes)

See more:

SQL-Server

Posted 31-Mar-13 19:53pm

Sharon 2

Add a Solution

2 solutions

Add a Solution

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

Mehdi Gholam · Answer 1 · 2013-03-31T20:10:00

Solution 1

You can return the @@IDENTITY variable (note this only works for the last inserted value i.e. you can't insert multiple rows and return all the row numbers):

SQL

insert into tablename (...) values (...)
select @@identity

Posted 31-Mar-13 20:10pm

Mehdi Gholam

Comments

Sharon 2 1-Apr-13 2:16am

how can return 2 rows from table in insertion procedure

Mehdi Gholam 1-Apr-13 2:21am

You can write select @@identity after each insert.

Aarti Meswania · Answer 2 · 2013-03-31T20:10:00

Solution 2

this way...

SQL

declare @return1 int;
set @return1=0; 
insert into table1(col1,col2) values('val1','val2'); 
select @return1=@@Identity;

insert into table1(col1,col2) values('val1','val2');
select @return1 as Insert1_PKey_Val, @@Identity as Insert2_PKey_Val;

it is store procedure then you can also use scope_identity function after insert statement

SQL

select Scope_Identity()

Happy Coding!
:)

Posted 31-Mar-13 20:10pm

Aarti Meswania

Updated 31-Mar-13 20:30pm

v2

Comments

Sharon 2 1-Apr-13 2:16am

how can return 2 rows from table in insertion procedure

Aarti Meswania 1-Apr-13 2:19am

didn't get it
can u give example that clear your requirement?

Sharon 2 1-Apr-13 2:17am

means 2 column vale

Aarti Meswania 1-Apr-13 2:30am

check updated solution

i want to inert values to a table and return its primary key and a column value during insertion

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

i want to inert values to a table and return its primary key and a column value during insertion

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us