How do I run an SQL script from the command line

Running an SQL script from the command line involves these steps:

Open a command prompt or terminal.
Navigate to the directory containing your SQL script.
Type sqlcmd -S [server_name] -U [username] -P [password] -d [database_name] -i [script_name].sql
Replace [server_name], [username], [password], [database_name], and [script_name].sql with the appropriate information.
Press Enter to execute the script.

Here are some additional tips:

Ensure you have the necessary permissions to run the script.
Use flags to specify additional options, such as outputting results to a file.
If you encounter errors, check the script syntax and ensure the server is available.

Can I run an SQL script without a password? Yes, by using the -E flag.
Can I run multiple SQL scripts at once? Yes, by using a semicolon ; to separate the script names.
Can I specify connection parameters in a script file? Yes, by using the CONNECT statement.
Can I use environment variables in my script? Yes, by using the % character, e.g., %USER%.
Are there alternatives to sqlcmd for running SQL scripts? Yes, such as psql for PostgreSQL and mysql for MySQL.

DHS DJ40W 3-Star Ping Pong Balls ABS New Material Professional ITTF Approved 40+ Table Tennis Balls for WTT Competition 6pcs/Box
$10.69

DHS DJ40+ 3 Stars Ping Pong Balls Professional 40+ Seamed Table Tennis Balls ABS New Material for WTT Competition ITTF Standard
$10.69

DHS DJ40+ 3 Stars Ping Pong Ball ITTF Standard 40+ Professional Table Tennis Balls ABS New Material for 2020 WTT Competition
$8.69

Original DHS 40+ 3 stars new cell dual table tennis ball new technology seam ball for ping pong racket game wholesales 10 balls
$90.55

DHS 2020 World Table Tennis Championships Dedicated Table Tennis 3-Star 40+Three Star Professional Competition WTT Balls
$170.47

DHS D40+ 3Star preferred ABS Table Tennis Balls
$10.23

Original Dhs Palio Sanwei 729 40+ 3 Stars New Table Tennis Ball New Technology For Ping Pong Racket Ittf Approved
$6.42

Original DHS 40+ 3 stars new cell dual table tennis ball new technology seam ball for ping pong racket game wholesales 10 balls
$111.13

Original DHS 40+ 3 stars new cell dual table tennis ball new technology seam ball for ping pong racket game wholesales 10 balls
$92.61

DHS Top Quality 3 Stars Table Tennis Balls 40 MM New Material Balls With Color Box For International Standard Competition
$176.08

Original 729 DHS JOOLA PALIO SANWEI 40+ 3 stars new table tennis ball new technology for ping pong racket game Olympic Games
$7.34

DHS 2020 World Table Tennis Championships Dedicated Table Tennis 3-Star 40+Three Star Professional Competition WTT Balls
$164.01

How do I run an SQL script from the command line?