Saturday, June 27, 2009

Where in the World is Common Parameter?

One thing I really like about the dynamic SQL approach to creating saved queries is that it allows me to re-use some base queries without having to parameterize them.

With a forms reference, the query is tightly linked to the form itself. That means one query for each form where you want to use that same syntax--with variable input for the form.

Sunday, June 21, 2009

Dude, Where's My Clause?

Lately I've been experimenting a lot with writing dynamic SQL for queries. Even though I'm starting to see some limitations, I'm pretty sure I like this approach a good deal . Today I'll just sketch out some basics and come back in future blogs to talk about the details, including the places where I think it makes a lot of sense--and where it looks like it might not ever really work.

Sunday, June 7, 2009

SQL Saturday

Oh Come All Ye Faithful.

I spent the day yesterday (June 6th) at the Portland SQLSaturday event. http://www.sqlsaturday.com/eventhome.aspx?eventid=16

Way cool, but, of course, I ran into the predictible "Access? I'm sorry" bias. (More on that later.)

I sat through sessions on: