I was trying to create a new table and insert data (schema and data) using a .sql file but due to huge file size was not able to do that.

So, using this page, I found below solution and that worked perfectly fine.

Run the script from the command line:

Open command prompt using run command: cmd

In command prompt use below query: SQLCMD -S serverName -E -d databaseName -i fileNameWithPath.sql

This was earlier shared by adrianm on (Jun 13, 2014 at 8:54)