|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Running queries stored as text in database
An general question.
A database table contains a textfield with queries. Is it possible to run them with another query. Code:
----ID----|-------------SQL------------------
0 |"Select * from table0
1 |"Select * from table2 where x = 3
or so? Does any one know? It would be nice if possible very dynamic but perhaps not so safe? |
|
#3
|
|||
|
|||
|
Yes of course it's possible in frontend with scripting have done that before just wondered if it would be possible to make it with a query. It would've been nice if it was possible!!
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Running queries stored as text in database |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|