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

Solapas principales

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

 

  • 0
  • 0
  • 115
  • 0
  • 1

Respuestas

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