?
Solved

Select Current ID on insert page of the tables current ID

Posted on 2008-10-11
2
Medium Priority
?
234 Views
Last Modified: 2012-06-22
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
0
Comment
Question by:vonfranzken
2 Comments
 
LVL 14

Accepted Solution

by:
Binuth earned 2000 total points
ID: 22693505
If you want the last identity value generated for the table "idea" ,use

SELECT IDENT_CURRENT( 'idea' )
0
 

Author Comment

by:vonfranzken
ID: 22693525
anyway to add one to the end so that I can lessen the work for them?
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how the fundamental information of how to create a table.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question