Is it possible to do this using only sql?Help plz

[Pe-Killer]

Is it possilbe to create a prompt in sql? Like for example The user should be prompted to enter a certain employee's name at the start of a query? without using a programming language
how do you, do this? can anyone maybe give me a link of a web-site that shows how to do this. I require it for a 3rd year project it's a database project am not allowed to use a programming language and i have no idea how to do this without using a programing language.
Thx

 

[bin3]

The only way is by stored procedures, which differs from database to database.

You will not get a 'prompt' as such, but you can call one with parameters, i.e something like exec sp_report @name="user" or something like that

 

[zamicro]

It depends on which database. Oracle does have the facility.

Edit: It also depends on which tool you are using.

 

[stevenv]

Unless your DBMS can produce executables, don't know how you would accomplish it without a programming language and compiler. SQL is a query language, it doesn't provide a user interface or development platform to produce applications. There may be specialized products out there but I'm not aware of any mainstream DBMS that provides such functionality.

 

[Nod]

Oracle:
http://www.orafaq.com/node/515
MySQL (won't prompt for value):
http://dev.mysql.com/doc/refman/5.0/en/user-variables.html

If you can make use of scripting, you could do something like:

#!/bin/bash
echo -e "Enter username : \c"
read USERNAME
mysql --user=user_name --password=your_password db_name < EOF
select ${USERNAME} from dual;
quit;
EOF

 

[lachesis]

can you use MSaccess? If so, at third year, you should have no problems finding out how. ;-)

 

[Other Pineapple Smurf]

Sounds like the requirement is for you to do it in a store procedure. Your SQL statement would then look like this:

> SELECT employeeNumber(12345);

This will then be executed by the stored procedure and display the results/perform the actions you require. Really cool to play with. I use them in my daily code.

 

[zaozzie]

You can use Microsoft access, Excel, Crystal Reports, MS reporting Services and other reporting/analytical tools.
You don't have to use SQL Server stored procs as using front end tools you can define parameters yourself that get added to the where clause automatically.

 

[Other Pineapple Smurf]

How many people actually bothered to read his post?

 

[ToxicBunny]

I'm wondering the same thing, I think most got to the first sentence and then answered...

I'm just wondering how exactly the question is posed in 3rd year...Mostly because something like MS SQL doesn't have the ability to take user input during execution as far as I am aware

 

[zamicro]

I'm wondering the same thing, I think most got to the first sentence and then answered...

I'm just wondering how exactly the question is posed in 3rd year...Mostly because something like MS SQL doesn't have the ability to take user input during execution as far as I am aware

I am also wondering. I asked the OP which database he is talking about, but the OP never came back.