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.
2010-03-08
10,451 reads
Fred Simmons
Blogs
The 5 Best SQL Course for Beginners – Reviews and Guide
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
Speaking at SQL Saturday Boston 2023
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Forums
Unable to deploy DACPAC
Every time the dev team runs their dacpac, they encounter an issue. "This deployment...
Error of No Corresponding Begin Tran not getting simulated
Hello, I have come across this peculiar problem. This stp is called every begin...
Scripting out AG code with Powershell
I'm trying to script out an availability group in SQL and found this neat...
Ask SSC