Fred Simmons

Converting Access Queries with iff() and DLookup() to SQL Server

This article gives a description of the iff() and DLookup() functions in Access 2007, and a method to converting them to SQL.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(38)

You rated this post out of 5. Change rating

2010-03-08

11,008 reads

My life has some crazy travel stretches for sure. Between speaking, office visits, customer...

In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...

I’m excited to announce the release of a new open-source project that fully automates...

Comments posted to this topic are about the item Server-Level Table sizes

Comments posted to this topic are about the item ORDER BY alias

Comments posted to this topic are about the item Optional Parameter Plan Optimization in...

There is a table tmp_tab:

CREATE TABLE tmp_tab (
id int,
val int
);

INSERT INTO tmp_tab VALUES
(1, 1),
(2, NULL),
(3, 3),
(4, 4),
(5, 5);

You want to order the rows ids by the following expression:

    ISNULL(val, id) + 1

Which of the following queries produces the expected ordering and why? (Select all correct)