Thread: How to select highest value and then create new object with that value +1?
View Single Post
  #2 (permalink)  
Old 12-06-2006, 01:51 PM
Musclebai
 
Posts: n/a
Default SQL 92 answer. Re: How to select highest value and then create new object with that value +1?
[sql]
INSERT INTO Item
(IID )
VALUES (SELECT (IID +1)
FROM Item
WHERE IID = convert(int,(SELECT MAX(IID ) FROM Item))
)
[/sql]
Edit/Delete Message Reply With Quote