Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-23 : 10:13:42
|
garykoh writes "hi,
My recent project allow people to make a query with their own SQL command. I need to store the SQL command in a user table. when user login, i need to retrieve all the user info as well as the result of SQL command stored in the field.
For example :
##condition field in user table will keep user SQL command as the following
user.condition ="select invoice_no from invoice"
Thus when i execute the following command, i will get back the stored SQL command. But what i acatually want is the result of the SQL command.
select user.condition from user where user.usrid = "123"
Any magic touch for that ?" |
|
|
|
|
|
Storing SQL