BIT Conversions

Question

BIT Conversions

Viewing 5 posts - 31 through 34 (of 34 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95460 More actions · Answer 1

buntyteg (8/14/2012)
in correct answer -1,1 is correct
but how 25 is correct
means to say... in bit datatype how we can store 25 (2 digit) value
??????

If it helps, think of it this way:

DECLARE @BitValue BIT;

SET @BitValue = CASE WHEN ValueToConvert = 0 THEN 0 ELSE 1 END;

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

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
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Ken SSCoach Points: 17191 More actions · Answer 2

Nice question. Made me pause for a moment. Thanks!

Revenant SSC-Forever Points: 42467 More actions · Answer 3

Revenant

SSC-Forever

Points: 42467

August 15, 2012 at 12:57 pm

#1526181

Thanks for an easy one, Wayne!

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Great question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

manik_anu SSCrazy Points: 2377 More actions · Answer 5

good questions......

manik123

**********

Manik
You cannot get to the top by sitting on your bottom.