Showing posts with label syscolumns. Show all posts
Showing posts with label syscolumns. Show all posts

Monday, 12 March 2012

SQL & ASP: custom queries for the user (a theoretical post)

   


This post was conceived as a theoretical experiment on dynamic queries. The original idea was to let the user create custom SQL queries against a database.
 The whole thing is not so crazy, and it kept forming in my mind while I was thinking about it.

Imagine a situation where a user can select a table from the list of tables in a SQL Server database. That is not a problem; infact we can retrieve table names with:
SELECT name
FROM sys.Tables