Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AdamWest
Constraint Violating Yak Guru
360 Posts |
 Posted - 2012-07-05 : 14:57:59
|
| what does this here mean? I have to translate to Oracle. "AND CAST(FLAGS AS BIGINT) & 1 = 1 " |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-05 : 15:05:04
|
| its checking if leftmost bit of FLAGS is set & represents bitwise AND operation------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-07-05 : 15:17:30
|
quote:
Originally posted by visakh16
its checking if leftmost bit of FLAGS is set & represents bitwise AND operation------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
I believe it is the rightmost bit - if not then please enlighten me.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-07-05 : 15:18:48
|
quote:
Originally posted by webfred
quote:
Originally posted by visakh16
its checking if leftmost bit of FLAGS is set & represents bitwise AND operation------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
I believe it is the rightmost bit - if not then please enlighten me.
No, you're never too old to Yak'n'Roll if you're too young to die.
sorry my badits rightmost bittime for a coffee i guess  ------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
need help with cast statement