2011-10-28
2,218 reads
Nakul Vachhrajani
- Twitter: @sqltwins
- Website: https://nakulvachhrajani.com/
- LinkedIn: https://www.linkedin.com/in/nakulvachhrajani/
2011-08-22
2,014 reads
2011-07-11 (first published: 2011-07-02)
2,073 reads
2010-12-30
2,943 reads
Connection Strings 101
This article introduces connection strings and suggests using MDAC to easily write efficient connection strings for those new to SQL Integration.
2010-12-24
5,458 reads
2010-11-29
2,606 reads
2010-11-04
3,205 reads
2010-10-06
3,258 reads
2010-10-04
3,021 reads
2010-09-29
3,140 reads
Blogs
FIRST_VALUE vs. Min: #SQLNewBlogger
By Steve Jones
I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...
Explicitly Defining Values in an IN Clause VS Putting Them into a Temp Table and Use a Semi-Join
This post comes off the back of my last, where I looked at issues...
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Forums
Networking Devices in Ellington, CT | Legacy Technology, Inc
In today’s connected world, a reliable network is the backbone of any successful business....
Cannot install development version.
A while into install I get a Microsoft OLE DB Driver for SQL Server....
More Funny SELECTs
Comments posted to this topic are about the item More Funny SELECTs
Question of the Day
More Funny SELECTs
What does this code return?
SELECT
( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2011'
AND soh.OrderDate < '01/01/2012') AS OrdersIn2000
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2012'
AND soh.OrderDate < '01/01/2013') AS OrdersIn2001
, ( SELECT COUNT (*), MAX(soh.OrderDate) AS latestorder
FROM Sales.SalesOrderHeader AS soh
WHERE
soh.OrderDate > '01/01/2013'
AND soh.OrderDate < '01/01/2014') AS OrdersIn2002;
GO See possible answers