how to pass parameter values to batchfiles

Question

I have a bacthfile & I want to pass parameter values, how can I do it ?

@echo off
ECHO Param1: Database Name: %1
ECHO Param2: Datasource : %2
ECHO Param3: DB User Id: %3
ECHO Param4: Password: %4

SET DBNAME=%1
SET DBSERVER=%2
SET DBUSER=%3
SET PASSWORD=%4

values which I want to set are DBNAME, DBSERVER, DBUSER and PASSWORDare parameters for batch file ?

What do you mean by hardcode the parameter values?

LittleBobbyTables - Au Revoir
– LittleBobbyTables - Au Revoir

2012-09-11 19:46:03 +00:00
Commented Sep 11, 2012 at 19:46 — LittleBobbyTables - Au Revoir
– LittleBobbyTables - Au Revoir, Commented Sep 11, 2012 at 19:46
i want to set values for DBNAME, DBServer, DBUser, password

msbyuva
– msbyuva

2012-09-11 19:52:00 +00:00
Commented Sep 11, 2012 at 19:52 — msbyuva
– msbyuva, Commented Sep 11, 2012 at 19:52

James K · Accepted Answer · 2012-09-15 05:03:11Z

4

You just pass parameters to a batch file by appending them to the end of the file name, with a space between each parameter:

FOO.BAT NorthwindDB ServerName msbyuva 12345

And if you need to pass spaces in a parameter, just surround it in quotes:

FOO.BAT NorthwindDB "Server Name" msbyuva 12345

And if you need to remove those quotes in FOO.BAT you can use ~ notation:

set ServerName=%~2

edited Sep 15, 2012 at 5:03

James K

4,0834 gold badges22 silver badges28 bronze badges

answered Sep 11, 2012 at 19:51

LittleBobbyTables - Au Revoir

33k25 gold badges113 silver badges115 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

msbyuva Over a year ago

Thank You LittleBobbyTables... I have never worked with batch files..thanks for your help..

Collectives™ on Stack Overflow

how to pass parameter values to batchfiles

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related