Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

Question

Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

gbritton1

SSCertifiable

Points: 6522
More actions
June 4, 2014 at 8:59 pm

#286269

Comments posted to this topic are about the item Fastest way to convert strings 'TRUE' and 'FALSE' to bit-values 1 and

Viewing 15 posts - 1 through 15 (of 26 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

EZ PZ lemon SQEEZEE

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

SQLRNNR (6/4/2014)
EZ PZ lemon SQEEZEE

+1

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

rhythmk SSCertifiable Points: 7271 More actions · Answer 3

Thanks for question.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

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

SQLRNNR (6/4/2014)
EZ PZ lemon SQEEZEE

+2

Thanks for the question.

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

Carlo Romagnano SSC-Insane Points: 22667 More actions · Answer 5

Thanks!

declare @t varchar(10) = 'FALSE'

,@b bit

SET @b-2 = CAST(@t as bit)

select @b-2

WHERE @b-2 = 'FALSE'

Mighty SSCrazy Eights Points: 9063 More actions · Answer 6

Easy one, but the most easy way of doing this was not an option:

SET @boolean = @TrueFalse

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

Thank you for the post, simple and nice.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 8

SQLRNNR (6/4/2014)
EZ PZ lemon SQEEZEE

+3

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

Mighty (6/5/2014)
Easy one, but the most easy way of doing this was not an option:
SET @boolean = @TrueFalse

+1

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Clive Strong SSChampion Points: 11222 More actions · Answer 10

I did pick the right option. However, all 3 could be the easiest, depending on your coding style.

Alternatively, you don't need the CAST.

SET @boolean = @TrueFalse

works just fine, too.

john.deprato Old Hand Points: 360 More actions · Answer 11

Doesn't work in SQL 2000. Just wanted to point that out 🙂

SqlMel SSCrazy Points: 2901 More actions · Answer 12

SqlMel

SSCrazy

Points: 2901

June 5, 2014 at 5:41 am

#1719158

+1.

Thanks!

---------------
Mel. 😎

Ed Wagner SSC Guru Points: 287026 More actions · Answer 13

It's nice to have a simple question every once in a while. Thanks.

This is the type of question that makes me REALLY think about the data type and how it works under the hood. Once you explore how it really works, it can help when you're writing code.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 14

Mighty (6/5/2014)
Easy one, but the most easy way of doing this was not an option:
SET @boolean = @TrueFalse

+1