<div>
After the insert statement select the @@Identity field eg:<br />
<br />
insert into a (a,b,c) values (1,2,3)<br />
select @@identity as newID<br />
<br />
will insert the record and return the new id in a field called newID
</div>


After the insert statement select the @@Identity field eg:

insert into a (a,b,c) values (1,2,3)
select @@identity as newID

will insert the record and return the new id in a field called newID

<div>
Thanks angellll, at least I know im not going nuts now. I'll &nbsp;contact the application writers.<br />
<br />
mkobrin - I think you misunderstood the question
</div>


Thanks angellll, at least I know im not going nuts now. I'll  contact the application writers.

mkobrin - I think you misunderstood the question

<div>
<div class="content wysiwyg-content">
I'm currently trying to write an insert query for a db and want to get the next value from a sequence for one of the insert fields.<br />
The only problem is I don't know what the sequence is called! I can query the table and see the sequences in there but I cant find out the actual name of the sequence??<br />
<br />
If anyone could help that would be great<br />
<br />
&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2011/03_w13/436287/Screen.JPG" target="_blank" title="Screenshot (37 KB)"><img alt="Screenshot" class="file-block lazyload" style="max-width: 706px;" data-src="https://filedb.experts-exchange.com/incoming/2011/03_w13/436287/Screen.JPG" /></a>
</div>
</div>


Screen.JPG

I'm currently trying to write an insert query for a db and want to get the next value from a sequence for one of the insert fields.
The only problem is I don't know what the sequence is called! I can query the table and see the sequences in there but I cant find out the actual name of the sequence??

If anyone could help that would be great

 

Find name of SQL Sequence

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.