Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Wednesday, July 20, 2016 2:06 PM
Points: 460, Visits: 539
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.greenarrow.net
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: Wednesday, August 10, 2016 2:45 PM
Points: 612, Visits: 232
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