CREATE TABLE TEST(ID NCHAR(8)) INSERT TEST SELECT 'E001' INSERT TEST SELECT 'E002' INSERT TEST SELECT 'E003' INSERT TEST SELECT 'E004' INSERT TEST SELECT 'E006' INSERT TEST SELECT 'E007' INSERT TEST SELECT 'E008' INSERT TEST SELECT 'E009' INSERT TEST SELECT 'E010' --SELECT * FROM TESTSELECT MAX(ID) AS ID FROM TESTDROP TABLE TEST
INSERT TEST SELECT 'E001'
INSERT TEST SELECT 'E002'
INSERT TEST SELECT 'E003'
INSERT TEST SELECT 'E004'
INSERT TEST SELECT 'E006'
INSERT TEST SELECT 'E007'
INSERT TEST SELECT 'E008'
INSERT TEST SELECT 'E009'
INSERT TEST SELECT 'E010'
--SELECT * FROM TESTSELECT MAX(ID) AS ID FROM TESTDROP TABLE TEST