Select Current ID on insert page of the tables current ID

I want to display the current id from the table idea so on the content managment insert idea page, I can let the administrator create a unique link to the details page.

Select  from dbo.idea
vonfranzkenAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BinuthConnect With a Mentor Commented:
If you want the last identity value generated for the table "idea" ,use

SELECT IDENT_CURRENT( 'idea' )
0
 
vonfranzkenAuthor Commented:
anyway to add one to the end so that I can lessen the work for them?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.