Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dr. Diana Dee » Bit data
Add to briefcase
22 posts, Page 1 of 3
123»»»

Bit data Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Dr. Diana Dee
Posted Tuesday, May 06, 2008 9:50 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:02 PM
Points: 2,768, Visits: 108
Comments posted to this topic are about the item Bit data
Post #496045
Bill Mell
Posted Wednesday, May 07, 2008 4:09 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Saturday, March 19, 2011 12:37 PM
Points: 603, Visits: 63
The question did not mention SQL 2005.
My answer was for SQL 2000.
Oh well.
Post #496164
shamshudheen
Posted Wednesday, May 07, 2008 4:41 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, June 10, 2009 10:50 PM
Points: 120, Visits: 211
hi

i am using sql 2000, then the answer is wrong
Post #496183
jim.powers
Posted Wednesday, May 07, 2008 6:59 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, February 04, 2013 10:00 AM
Points: 1,329, Visits: 803
The question does specifically request the results from SQL Server 2005.
Post #496270
webrunner
Posted Wednesday, May 07, 2008 7:18 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:47 PM
Points: 2,118, Visits: 2,213
jim.powers (5/7/2008)
The question does specifically request the results from SQL Server 2005.


Yes, it does.

What will be the result when the following query is executed on SQL Server 2005?


Also, and this depends on knowing the sample databases, but AdventureWorks is one of the new sample databases for SQL 2005.

Reference:
http://blog.sqlauthority.com/2007/05/23/sql-server-2005-northwind-database-or-adventureworks-database-samples-databases/

-------------------
"The chemistry must be respected." - Walter White

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #496294
Dr. Diana Dee
Posted Wednesday, May 07, 2008 7:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:02 PM
Points: 2,768, Visits: 108
I was very careful to specify SQL 2005 because SQL 2000 behaves differently.

I was inspired to post this question because one of my students used WHERE = 'true' for a bit column. I tested that in SQL 2000 and it did not work, so I told the student he was wrong. However, when I tested that in SQL 2005, it worked.

I was not trying to trick anyone, since I explicitly specified SQL 2005, and found an example from the AdventureWorks database.

)
Post #496307
GSquared
Posted Wednesday, May 07, 2008 7:37 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571
It's a good question and gives all the necessary information.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #496314
SanjayAttray
Posted Wednesday, May 07, 2008 8:33 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554
WHERE SalariedFlag = 'true' for bit would not work in 2000 but since it says use Adventureworks, it clear that the question is for SQL 2005.

SQL DBA.
Post #496383
Dr. Diana Dee
Posted Wednesday, May 07, 2008 8:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 19, 2013 3:02 PM
Points: 2,768, Visits: 108
True.

And I explicitly said "2005" in the body of the question.

)
Post #496398
Lynn Pettis
Posted Wednesday, May 07, 2008 8:57 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:51 PM
Points: 21,627, Visits: 27,482
Just a problem with some people not reading the entire question. The question did specifically state SQL Server 2005.

Good question, everything specified to be able to make an educated guess at the answer.

Well done.


Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #496412
« Prev Topic | Next Topic »

Add to briefcase
22 posts, Page 1 of 3
123»»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.