Bit data

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Dr. Diana Dee » Bit data

22 posts, Page 2 of 3

««1 2 3 »»

Bit data

Rate Topic

Display Mode

Topic Options

Author

Message

Dr. Diana Dee

Posted Wednesday, May 07, 2008 9:03 AM

SSCrazy

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

Thank you.

I myself have trouble noticing everything in the questions! (LOL)

I did give an AdventureWorks example so people could actually test for the result.

) BigGrin

Post #496418

kk-479046

Posted Wednesday, May 07, 2008 11:12 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 14, 2010 3:35 PM
Points: 509, Visits: 96

Good Question Dr.Dee! I guess writing our queries like SalariedFlag = 'TRUE' makes it more readable. But I wonder if there would be any performance degrade when we use 'TRUE' instead of 1?

KK

Post #496540

Dr. Diana Dee

Posted Wednesday, May 07, 2008 11:38 AM

SSCrazy

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

I suppose one could test whether the implicit conversion has a cost by creating a table with several million rows and running the query each way.

Unfortunately, I'm too busy (translation: I don't care enough!)

) BigGrin

Post #496555

Christian Buettner-167247

Posted Wednesday, May 07, 2008 2:44 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:06 AM
Points: 2,525, Visits: 3,618

Good Question!

Although I doubt that this new implicit conversion is an improvement for SQL Server.

I would be interested to know why they have not allowed TRUE or FALSE as bool keywords so far.
Does anyone know if this is a technical restriction?

(But at least they (TRUE and FALSE) have been reserved as "FUTURE KEYWORDS")

Best Regards,
Chris Büttner

Post #496700

Anipaul

Posted Thursday, May 08, 2008 1:06 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 4,787, Visits: 1,336

Another goodie...............:)

Post #496898

David Harder

Posted Thursday, May 08, 2008 7:40 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 9:09 AM
Points: 3,550, Visits: 922

A good question.

Post #497102

Dr. Diana Dee

Posted Thursday, May 08, 2008 7:59 AM

SSCrazy

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

Thank you, Anirban and David.

) BigGrin

Post #497118

Anipaul

Posted Thursday, May 08, 2008 9:39 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 4,787, Visits: 1,336

Dr. Diana Dee (5/8/2008)

Thank you, Anirban and David.

) BigGrin

You are welcome........:)

Post #497206

Terry Maher

Posted Friday, May 09, 2008 7:02 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 12, 2010 5:56 AM
Points: 79, Visits: 45

This was a very good question. I did not know that 'true' and 'false' can not be used with bit columns in SQL 2005. I can now stop having to write DECLARE @TRUE BIT SET @TRUE = 1 statements in my procedures:)

Post #497830

alvandkoohi

Posted Sunday, May 11, 2008 9:55 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, March 02, 2013 12:48 AM
Points: 4, Visits: 109

sql 2000 with error
Msg 245, Level 16, State 1, Line 1
Syntax error converting the varchar value 'true' to a column of data type bit.
sql 2005 without error

Post #498531

« Prev Topic | Next Topic »

22 posts, Page 2 of 3

««1 2 3 »»

Permissions