SELECT options refine results As we saw in the last article, the SQL SELECT statement has the ... A keyword triggers functionality within the database. These are sometimes required with queries ...

So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?

Inside a relational database management system ... This facet is why a view may be described as simply a “named” query. As one composes SQL Select statements, the author may use another query in place ...