How to use Scope_Identity() to get string key

Question

4.00/5 (1 vote)

See more:

Is Scope_Identity() only valid if table has int key value. If table has string key how can I use this to take last updated/added key.

Posted 21-Mar-11 22:14pm

Sanyon_d

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)

Wayne Gaylard · Answer 1 · 2011-03-21T23:29:00

Scope_Identity only works on identity fields in a database. I think you are being confused with Primary Fields and Identity Fields. An Identity field is only updated by the pertaining RDMS in their own particular fashion(most implement AutoNumber fields, some implement GUID fields), while Primary keys can be any datatype, and are usually updated by the developer/stored proc etc. Whilst a Primary field can also be an Identity field, it is not necessarily so. Scope_Identity will therefore only work on Identity columns.

Mahendra.p25 · Answer 2 · 2011-03-21T23:41:00

hi,
try this
INSERT INTO mySchoolRecord (StudentId,Name,[Address],Contact) OUTPUT INSERTED.StudentId VALUES ('abcdesfg','Mr. Peter','United States', 256 )

if your are using Guid then try this

DECLARE @ClientID uniqueidentifier
DECLARE @MyTableVar table ( ClientID uniqueidentifier )

INSERT INTO Client (ClientName, Address1, Address2)
OUTPUT INSERTED.ClientID INTO @MyTableVar
VALUES ('AAAA', 'Street', 'place')
SELECT @ClientID = ClientID FROM @MyTableVar

How to use Scope_Identity() to get string key

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0