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 - 2005-10-06 : 07:53:44
|
| Joseph writes "Dear all,I want to store my whole query into different tables like tables for where clause, order clause, column list, table name etc.and then I want to regenerate a sql query from given id.for this id, I want to recreate new query from above tables and then execute this newly created query to get new table.my question is how can I achieve this ?If you provide me whole example then it will be better for me.Thank you in advance." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-10-06 : 07:54:08
|
| Ummmm, why? |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-07 : 02:09:10
|
| you can do this using dynamic sql but there are performance and security issues you need to consider--------------------keeping it simple... |
|
|
|
|
|
|
Regeneration and execution of Qeury