Ufdjrw

Store Dynamic-accessible hidden metadata in a cell

Is every episode of "Where are my Pants?" identical?

Are spiders unable to hurt humans, especially very small spiders?

Do working physicists consider Newtonian mechanics to be "falsified"?

Can the Right Ascension and Argument of Perigee of a spacecraft's orbit keep varying by themselves with time?

Word for: a synonym with a positive connotation?

Are there continuous functions who are the same in an interval but differ in at least one other point?

Button changing its text & action. Good or terrible?

One-dimensional Japanese puzzle

Working through the single responsibility principle (SRP) in Python when calls are expensive

Word to describe a time interval

How many cones with angle theta can I pack into the unit sphere?

What to do when moving next to a bird sanctuary with a loosely-domesticated cat?

The following signatures were invalid: EXPKEYSIG 1397BC53640DB551

Was credit for the black hole image misappropriated?

Drawing vertical/oblique lines in Metrical tree (tikz-qtree, tipa)

Windows 10: How to Lock (not sleep) laptop on lid close?

How do you keep chess fun when your opponent constantly beats you?

How did the audience guess the pentatonic scale in Bobby McFerrin's presentation?

How to make Illustrator type tool selection automatically adapt with text length

Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?

Why not take a picture of a closer black hole?

Simulating Exploding Dice

Why did Peik Lin say, "I'm not an animal"?

How to get user input from a bat file in sql server pdw?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I want to get user input from a batch file and then use the string entered by the user into a SQL file.

For example, I have a batch file called test.bat. When I execute that, I should be prompted to enter a value, and after entering that value it should be used in my SQL file.

How can I do that?

sqlcmd

share|improve this question

edited Mar 8 at 17:21

Pikachu the Purple Wizard

2,05161529

asked Mar 8 at 12:19

Avneet KaurAvneet Kaur

1

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Show us what you have tried so far. Nobody here will implement the whole program for you.
  
  – nkr
  Mar 8 at 12:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have created a bat file named test.bat as below :- sqlcmd -v item="%item%" -v cost=%cost% -i test.sql sqlcmd -S "172.16.253.72,17001" -U user -P pdw -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt so when i will run this file it should prompt me for the value of item and cost. but then how can i fetch the value entered bt the user in a variable
  
  – Avneet Kaur
  Apr 2 at 10:18
  
  

  
  
  
  

add a comment | 

0

I want to get user input from a batch file and then use the string entered by the user into a SQL file.

For example, I have a batch file called test.bat. When I execute that, I should be prompted to enter a value, and after entering that value it should be used in my SQL file.

How can I do that?

sqlcmd

share|improve this question

edited Mar 8 at 17:21

Pikachu the Purple Wizard

2,05161529

asked Mar 8 at 12:19

Avneet KaurAvneet Kaur

1

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  Show us what you have tried so far. Nobody here will implement the whole program for you.
  
  – nkr
  Mar 8 at 12:27
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have created a bat file named test.bat as below :- sqlcmd -v item="%item%" -v cost=%cost% -i test.sql sqlcmd -S "172.16.253.72,17001" -U user -P pdw -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt so when i will run this file it should prompt me for the value of item and cost. but then how can i fetch the value entered bt the user in a variable
  
  – Avneet Kaur
  Apr 2 at 10:18
  
  

  
  
  
  

add a comment | 

I want to get user input from a batch file and then use the string entered by the user into a SQL file.

For example, I have a batch file called test.bat. When I execute that, I should be prompted to enter a value, and after entering that value it should be used in my SQL file.

How can I do that?

sqlcmd

share|improve this question

edited Mar 8 at 17:21

Pikachu the Purple Wizard

2,05161529

asked Mar 8 at 12:19

Avneet KaurAvneet Kaur

1

share|improve this question

edited Mar 8 at 17:21

Pikachu the Purple Wizard

2,05161529

asked Mar 8 at 12:19

Avneet KaurAvneet Kaur

1

share|improve this question

edited Mar 8 at 17:21

Pikachu the Purple Wizard

2,05161529

asked Mar 8 at 12:19

Avneet KaurAvneet Kaur

1

edited Mar 8 at 17:21

Pikachu the Purple Wizard

2,05161529

edited Mar 8 at 17:21

Pikachu the Purple Wizard

2,05161529

asked Mar 8 at 12:19

Avneet KaurAvneet Kaur

1

asked Mar 8 at 12:19

Avneet KaurAvneet Kaur

1

1 Answer
1

active

oldest

votes

0

You should add at the top of your .bat file these tow lines which read user input for the two parameters you are using

set /p item=Enter item: 
set /p cost=Enter cost: 

share|improve this answer

answered Apr 2 at 10:51

Kemal AL GAZZAHKemal AL GAZZAH

40726

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry forgot to mention, but yes i have added these statements in my batch file.
  
  – Avneet Kaur
  Apr 2 at 10:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  then, it is not working ?, can you post the whole bat file you are using
  
  – Kemal AL GAZZAH
  Apr 2 at 10:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here you go : sqlcmd -S "172.16.253.72,17001" -U user1 -P pwd -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt set /p item=Item : set /p cost=Cost : sqlcmd -v item="%item%" -v cost=%cost% -i test.sql sqlcmd -S "172.16.253.72,17001" -U user1 -P pwd -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt pause
  
  – Avneet Kaur
  Apr 2 at 10:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you post the complete bat file with the two lines added (set /p item=...)
  
  – Kemal AL GAZZAH
  Apr 2 at 14:14
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can i get help over this ?
  
  – Avneet Kaur
  Apr 3 at 9:54
  
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55063116%2fhow-to-get-user-input-from-a-bat-file-in-sql-server-pdw%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You should add at the top of your .bat file these tow lines which read user input for the two parameters you are using

set /p item=Enter item: 
set /p cost=Enter cost: 

share|improve this answer

answered Apr 2 at 10:51

Kemal AL GAZZAHKemal AL GAZZAH

40726

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry forgot to mention, but yes i have added these statements in my batch file.
  
  – Avneet Kaur
  Apr 2 at 10:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  then, it is not working ?, can you post the whole bat file you are using
  
  – Kemal AL GAZZAH
  Apr 2 at 10:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here you go : sqlcmd -S "172.16.253.72,17001" -U user1 -P pwd -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt set /p item=Item : set /p cost=Cost : sqlcmd -v item="%item%" -v cost=%cost% -i test.sql sqlcmd -S "172.16.253.72,17001" -U user1 -P pwd -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt pause
  
  – Avneet Kaur
  Apr 2 at 10:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you post the complete bat file with the two lines added (set /p item=...)
  
  – Kemal AL GAZZAH
  Apr 2 at 14:14
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can i get help over this ?
  
  – Avneet Kaur
  Apr 3 at 9:54
  
  

  
  
  
  

add a comment | 

0

You should add at the top of your .bat file these tow lines which read user input for the two parameters you are using

set /p item=Enter item: 
set /p cost=Enter cost: 

share|improve this answer

answered Apr 2 at 10:51

Kemal AL GAZZAHKemal AL GAZZAH

40726

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry forgot to mention, but yes i have added these statements in my batch file.
  
  – Avneet Kaur
  Apr 2 at 10:53
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  then, it is not working ?, can you post the whole bat file you are using
  
  – Kemal AL GAZZAH
  Apr 2 at 10:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Here you go : sqlcmd -S "172.16.253.72,17001" -U user1 -P pwd -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt set /p item=Item : set /p cost=Cost : sqlcmd -v item="%item%" -v cost=%cost% -i test.sql sqlcmd -S "172.16.253.72,17001" -U user1 -P pwd -d Master -I C:Maintenancetest_blocking_backuptest.sql -o C:Maintenancetest_blocking_backupoutput.txt pause
  
  – Avneet Kaur
  Apr 2 at 10:59
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can you post the complete bat file with the two lines added (set /p item=...)
  
  – Kemal AL GAZZAH
  Apr 2 at 14:14
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  can i get help over this ?
  
  – Avneet Kaur
  Apr 3 at 9:54
  
  

  
  
  
  

add a comment | 

You should add at the top of your .bat file these tow lines which read user input for the two parameters you are using

set /p item=Enter item: 
set /p cost=Enter cost: 

share|improve this answer

answered Apr 2 at 10:51

Kemal AL GAZZAHKemal AL GAZZAH

40726

set /p item=Enter item: 
set /p cost=Enter cost: 

share|improve this answer

answered Apr 2 at 10:51

Kemal AL GAZZAHKemal AL GAZZAH

40726

answered Apr 2 at 10:51

Kemal AL GAZZAHKemal AL GAZZAH

40726

answered Apr 2 at 10:51

Kemal AL GAZZAHKemal AL GAZZAH

40726