How to execute multiple query or script in sql management studio? |

I want to insert multiple records in the table using below queries, but it gives an error.

Answers

Answer by Robert Cemper 8 days ago

Insert into LISDB.State (short,long) SELECT 'AL','Alabama' Union All SELECT 'AK','Alaska' Union All SELECT 'AZ','Arizona' Union All SELECT 'AR','Arkansas'

0 0