<div>
you need to create a procedure in sql server <br />
<br />
read this <br />
<a href="http://jamesthornton.com/software/coldfusion/nextval.html" rel="ugc">http://jamesthornton.com/software/coldfusion/nextval.html</a>
</div>


<div>
one more article <br />
<br />
<a href="http://www.sqlmag.com/Article/ArticleID/46900/sql_server_46900.html" rel="ugc">http://www.sqlmag.com/Article/ArticleID/46900/sql_server_46900.html</a>
</div>


<div>
anees<br />
<br />
so with this example as you attached I now have a field called LocationsID with I want to populate the keys during my insert<br />
<br />
what do I use<br />
<br />
i.e insert into work(locationsID)values(??<wbr />?????)<br />
<br />
what must I call this field?
</div>


<div>
f you need that colun to be automaticlly incremented, then modify that column as identity <br />
<br />
ALTER TABLE Work<br />
ALTER COLUMN LocationsID int IDENTITY
</div>


<div>
anees,<br />
<br />
see i have to do an insert of 100's of records<br />
<br />
could you help me with this solution please in the form of a working example with the table work<br />
<br />
all help will be highly regarded<br />
<br />
r
</div>


<div>
<div class="content wysiwyg-content">
folks<br />
<br />
the function nextval,is it from oracle and what does it do? what is it in sql server?<br />
<br />
rutger
</div>
</div>


folks

the function nextval,is it from oracle and what does it do? what is it in sql server?

rutger

you need to create a procedure in sql server 

read this 
http://jamesthornton.com/software/coldfusion/nextval.html

one more article 

http://www.sqlmag.com/Article/ArticleID/46900/sql_server_46900.html

anees

so with this example as you attached I now have a field called LocationsID with I want to populate the keys during my insert

what do I use

i.e insert into work(locationsID)values(???????)

what must I call this field?

f you need that colun to be automaticlly incremented, then modify that column as identity 

ALTER TABLE Work
ALTER COLUMN LocationsID int IDENTITY

anees,

see i have to do an insert of 100&#39;s of records

could you help me with this solution please in the form of a working example with the table work

all help will be highly regarded

r

nextval in sql server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.