I have the following sql statement:
INSERT INTO prg_lvl VALUES (
( select max(menu_id) + 1 from prg_lvl ),
that works for Sybase and I wanna make it works for SQL Server.
The problem is the use ot the subquery (select max(menu_id) + 1 from prg_lvl).
Could I use subqueries in SQL Server in general or is there is any other method to overcome this problem