CODEWITHSUNDEEP
sqlwindows
Denslat
Denslat

Reputation: 179

SQL, small program to run a query based on the input the user provides

I'm looking into creating a small SQL based program that will run a single query based on an input from a user, but to be honest I know SQL but have no idea on any other Programming language. Does anyone know if someone has developed something like this, and if so a link to where to find it?

to give an idea, A windows box pops up with an entry field, that entry field is using the "set @Query" Declarable variable, it then runs a pre-existing SQL Query on that variable and prints to the user the result.

If anything is unclear please let me know Your humble newbie.

Denslat

Upvotes: 0

Views: 309

Answers (2)

Surajeet Bharati
Surajeet Bharati

Reputation: 1433

You can install Oracle Database in your system. It has an interactive and batch query tool namely SQL*Plus which has its own command line interface,GUI and web based interface. You can run your own interactive SQL script in its Command Line Interface very easily. In future, for more advanced development, you can use Oracle SQL Developer.

And you need not know any other programming language. Just learn how to get input from user in SQL. Let me know if you face any problem.

Upvotes: 0

Kenan Zahirovic
Kenan Zahirovic

Reputation: 1597

You can use sqlcmd utility, it's a part of SQL Server. For more info, see this link.

You don't have to learn new language, you just need to know how to get an user input and call query.

For mode advance situations, you can even couple sqlcmd with PowerShell. See here.

Upvotes: 2

Related Questions