SQL is not effective for the task you are describing. A high-level language such as Python/Java/C# would allow you to easily prompt for user input and would arguably be more suited to the job.

Oct 1, 2022 · If you want SQL Prompt, its $179 /yr only. Your alternative for prompt would be the free Apex Complete, but it doesn't hold a candle against prompt and from experience gets in the way of …

Jan 20, 2012 · From Workbench: File > Run SQL Script -- then follow prompts From Windows Command Line: Option 1: mysql -u usr -p mysql> source file_path.sql Option 2: mysql -u usr -p '-e …

Mar 1, 2007 · I am trying to get the user to input the date into a substitution variable but want the prompt message to prompt the user to input the date in the correct format. SELECT claimdate, …

providing a file name containing all my SQL queries is much more handy than providing the SQL query as command-line arguments.

Aug 19, 2016 · I have written couple of sql scripts in a text file and saved them with a .sql extension. I want to execute these scripts in the sql plus terminal without having to manually type the standalone …

Mar 21, 2014 · Sqlcmd -u username -p password assumes a username & password for the SQL Server already setup Alternatively how can I setup a user account from command prompt? I've SQL Server …

Sep 19, 2019 · Redgate SQL Prompt is a good tool, but I prefer dbForge SQL Complete. If you are wondering why, I recommend an article that compares the features of three tools - dbForge SQL …

Jan 18, 2017 · Does anyone know of a way to use the @Prompt in SQL for SAP WEBI 4.2? - Or any other way to have 'flexible' time dimensions where it is possible to set a from-date or to-date …

Dec 3, 2013 · What are the possible ways to determine the deployed SQL Server version? I’ve tried to do it using the SQL Server software. I want to do it using a command line SQL statement.