Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Bit data Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2008 10:11 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, February 6, 2014 9:39 AM
Points: 420, Visits: 487
This is a great question, but the answer would be no rows returned because they would still be all NULL since you did not insert or update any rows before the select.

The answer that is supplied as the correct answer would only be correct if you added a step like this:

USE AdventureWorks
UPDATE HumanResources.Employee
SET SalariedFlag = 'true'

I want my point for the correct answer:

A result set with no value (a blank result) will be returned.


Joshua Perry
http://www.usesage.com
Post #504642
Posted Tuesday, June 3, 2008 10:15 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, June 23, 2014 6:40 PM
Points: 612, Visits: 212
Good informative question...This will at least make people to read whole question before replying and commenting......:)
Post #510819
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse