(Similar question related to SQL Server : SO Link)
I know in Sql Server 2008 or above, you can insert multiple rows doing the following:
INSERT INTO MyTable (Name, ID)
VALUES ('First',1), ('Second',2), ('Third',3)
However, it seems like this syntax DOES NOT work in Sybase Adaptive Server Enterprise, since this gives me an error..
Anyone know the syntax in Sybase that achieves the same thing?
Sybase ASE is based on Transact SQL..
Thanks
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…