I have a table with the following schema, that contains TSQL queries.
| ID | ViewName | Query |
|---|---|---|
| 1 | vwPersons | Select * from tblPersons |
| 2 | vwPosts | Select * from tblPosts |
How can I select the second query (ID=2) from the above table and execute that query?
Asked
Active
Viewed 163 times
0
Leszek Mazur
- 2,443
- 1
- 14
- 28
Saeed Aghdam
- 307
- 3
- 11
-
A table of views? Are you writing a new DBMS? – Thorsten Kettner May 10 '16 at 15:02
-
Nope, actually I use SQLCE, and all we know that SQLCE does not support features like View. – Saeed Aghdam May 10 '16 at 15:17
-
Removed answer, as it appears, sql server CE doesn't support dynamic querying. I don't think it's possible to do what you want in CE, unless you can do it in (.NET) application. – HoneyBadger May 11 '16 at 08:43