How to set Scope identity

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi

In my DO table SlNo column have identity now i i have to set Scope identity for the same.below my code

C#

string sqlcommand = "SELECT DoNo,SlNo from DO where DoNo = DoNo, SET @SlNo=CAST(SCOPE_IDENTITY() AS int";

Could you please help how to set?

At present i am getting a error msg error near int.

Regards
Lancy

Posted 5-Nov-11 5:36am

Lancy.net

Updated 5-Nov-11 5:39am

RaisKazi

v2

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)

Not Active · Answer 1 · 2011-11-05T05:40:00

Solution 1

Try reading this http://msdn.microsoft.com/en-us/library/ms190315.aspx[^] to understand what SCOPE_IDENTITY is.

Posted 5-Nov-11 5:40am

Not Active

Amir Mahfoozi · Answer 2 · 2011-11-05T20:23:00

Solution 2

Try this :

C#

string sqlcommand = "SELECT DoNo,SlNo from DO where DoNo = DoNo; SET @SlNo=CAST(SCOPE_IDENTITY() AS int)";

Substituted "," by ";" between two commands and added a parentheses at the end.

Posted 5-Nov-11 20:23pm

Amir Mahfoozi

Comments

[no name] 6-Nov-11 10:32am

You should also read what SCOPE_IDENTITY is. It has no bearing on select statements and is meaningless in this context

Amir Mahfoozi 6-Nov-11 14:44pm

However you're right and also I know its function but I was focusing on : "At present i am getting a error msg error near int.". And I agree with you that SCOPE_IDENTITY is non applicable in here.

How to set Scope identity

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to set Scope identity

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us