I have a *.sql file, the point here is when I press the Execute in SSMS, I get an error:

Msg 111, Level 15, State 1, Line 2
‘CREATE SCHEMA’ must be the first statement in a query batch.

Msg 10738, Level 15, State 1, Line 1034
The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values

Therefore, I can not copy and paste this script and execute it. Is there another way to import a large *.sql file?

I have two tables in the database, and one of them has 12,234 rows.