how to create a batch file to edit sql query

Question

I need to create a batch file which should be parameterised

my Query

select * from glob2("parameterised value what the user is entering")

Joey · Accepted Answer · 2012-10-02 07:04:32Z

1

You can use set /p to query the user for input:

set /p value=Enter something:

You can then subsequently use the variable; in this case %value%.

answered Oct 2, 2012 at 7:04

Joey

357k88 gold badges705 silver badges700 bronze badges

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

Comments

PA. · Accepted Answer · 2012-10-02 07:05:41Z

1

In your code you can access the command line parameters by referring to %1 %2 etc.

Read HELP CALL and try this

@echo off
echo QUERY SELECT * FROM GLOB2 WHERE NAME="%1"

answered Oct 2, 2012 at 7:05

PA.

29.5k10 gold badges77 silver badges102 bronze badges