Batch file to execute SQL Server Stored Procedure

@echo OFF
SET ServerName=.\EXPR
SET Loc=C:\DataUpload\AccessDB
SET Schema=MDM
ECHO DB Server is %ServerName%
ECHO Location is   %Loc%
ECHO Schema is   %Schema%
ECHO Parameter 1 is %1
PAUSE
sqlcmd -Q "EXEC  [MDM].[dbo].[MDMSync]   '%Loc%'" -S   %ServerName% -d  %Schema%
PAUSE

Parameterized Script

@echo OFF
ECHO DB Server is %1
ECHO Schema is  %2
ECHO Location is %3
PAUSE
sqlcmd -Q "EXEC  [MDM].[dbo].[MDMSync]   '%3'" -S   %1 -d  %2