Bit by bit

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 Prakriti Agrawal » Bit by bit

29 posts, Page 1 of 3

1 2 3 »»»

Bit by bit

Rate Topic

Display Mode

Topic Options

Author

Message

agrawal.prakriti

Posted Wednesday, January 27, 2010 8:12 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 27, 2010 1:31 PM
Points: 132, Visits: 101

Comments posted to this topic are about the item Bit by bit

Post #854871

SanjayAttray

Posted Wednesday, January 27, 2010 8:13 PM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

Easy one.

SQL DBA.

Post #854872

mohammed moinudheen

Posted Wednesday, January 27, 2010 8:29 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 7:43 PM
Points: 2,174, Visits: 3,586

Good question. Tests the basic Smile

Mohammed Moinudheen

Post #854878

Bhavesh_Patel

Posted Wednesday, January 27, 2010 10:07 PM

SSChasing Mays

Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621, Visits: 297

Points for taking ... Tongue

Bhavesh Patel

http://bhaveshgpatel.wordpress.com/

Post #854900

WayneS

Posted Wednesday, January 27, 2010 10:10 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 AM
Points: 6,370, Visits: 8,235

Bhavesh_Patel (1/27/2010)

Points for taking ... Tongue

Makes up for yesterdays (though points were awarded anyway...)

Wayne
Microsoft Certified Master: SQL Server 2008

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings

Post #854901

SQLRNNR

Posted Wednesday, January 27, 2010 10:16 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337

Thanks for the question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #854905

ziangij

Posted Wednesday, January 27, 2010 11:08 PM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,530, Visits: 359

easy one

Post #854932

Toreador

Posted Thursday, January 28, 2010 2:05 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761

"if a number larger than one is used, it is converted to one."

I thought the actual explanation was that anything other than 0 (false) is treated as true and hence is stored as 1. So a number larger than 1 becomes 1, but so does any number less than 1, apart from 0.

Post #854994

Bob Cullen-434885

Posted Thursday, January 28, 2010 2:19 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:52 AM
Points: 509, Visits: 388

OK. I am in the 17% who got it wrong - I replied "Error". And now I know. But will somebody kindly explain why BIT is treated any differently to TINYINT, SMALLINT, INT, etc. It is, after all, only a type that has a range of valid values. If the others report an overflow error when I try to assign values outside their permitted range, why not BIT also?

Post #855002

Toreador

Posted Thursday, January 28, 2010 2:32 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761

Here's a slightly better reference
http://msdn.microsoft.com/en-us/library/ms191530(SQL.90).aspx#_bit

"Converting to bit promotes any nonzero value to 1"

Post #855012

« Prev Topic | Next Topic »

29 posts, Page 1 of 3

1 2 3 »»»

Permissions