echo. set /p db=Enter your database name. (enter) set /p wh=Enter the 4 digit warehouse number of the warehouse you want to clone. (enter) set /p newwh=Enter the new 4 digit warehouse number. (enter) sqlcmd -Slocalhost\ESC -E -Q "use %db% update InvQuan Set WH = '%newwh%' where WH = '%wh%'" pause