Question: (Similar question related to SQL Server : [**SO Link**](https://stackoverflow.com/questions/2624713/how-do-i-insert-multiple-rows-without-repeating-the-insert-into-dbo-blah-part))

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

Answer: 
try this:

```
INSERT INTO MyTable (Name, ID)
Select 'First',1
Union All 
Select 'Second',2
Union All
Select 'Third',3

```

I know this works on older versions of SQL server, and suspect that it will work with sybase.
The syntax in SQL Server for this example will not work in Sybase. Either go with individual statements, or UNION ALL clause