Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Patrick LeBlanc SELECT and WHERE without FROM RE: SELECT and WHERE without FROM
Andrew Watson-478275
SSCarpal Tunnel
Points: 4652
More actions
June 23, 2011 at 3:17 am
#1342882
You don't even need the WHERE clause. I've just done an SSIS step where I needed a single row returned, but didn't care about the contents, so I used
SELECT 1
and it worked fine.