Click here to Skip to main content
16,020,424 members
Home / Discussions / Database
   

Database

 
QuestionADO sql server Pin
audhie2-Nov-06 23:11
audhie2-Nov-06 23:11 
AnswerRe: ADO sql server Pin
audhie2-Nov-06 23:13
audhie2-Nov-06 23:13 
GeneralRe: ADO sql server Pin
Colin Angus Mackay3-Nov-06 0:09
Colin Angus Mackay3-Nov-06 0:09 
GeneralRe: ADO sql server Pin
Russell Jones6-Nov-06 5:50
Russell Jones6-Nov-06 5:50 
GeneralRe: ADO sql server Pin
Russell Jones6-Nov-06 5:53
Russell Jones6-Nov-06 5:53 
QuestionDivide by zero error encountered.??? how?? [urgent] Pin
campbells2-Nov-06 21:48
campbells2-Nov-06 21:48 
AnswerRe: Divide by zero error encountered.??? how?? [urgent] Pin
ChandraRam2-Nov-06 22:33
ChandraRam2-Nov-06 22:33 
Questionbinary bit manipulation - possible? Pin
neilsolent2-Nov-06 21:41
neilsolent2-Nov-06 21:41 
All,

I have the following table

CREATE TABLE TEST
(
TEST1 binary(32)
)
go

The TEST1 column is a binary with 256 bits.
How can I write T-SQL code to turn an arbitrary bit in TEST1 on or off, or check its state?
You obviously get arithmetic overflow if you try something like:

INSERT INTO TEST VALUES(0)
go

UPDATE TEST SET TEST1 = TEST1 | POWER(2, 137) /* Try to set bit 138 to "on" */
go

"............ Arithmetic overflow occurred ......."


Any ideas?




cheers,
Neil

AnswerRe: binary bit manipulation - possible? Pin
Mike Dimmick3-Nov-06 3:22
Mike Dimmick3-Nov-06 3:22 
GeneralRe: binary bit manipulation - possible? Pin
neilsolent3-Nov-06 3:44
neilsolent3-Nov-06 3:44 
GeneralRe: binary bit manipulation - possible? Pin
neilsolent4-Nov-06 7:18
neilsolent4-Nov-06 7:18 
AnswerRe: binary bit manipulation - possible? Pin
Eric Dahlvang3-Nov-06 3:44
Eric Dahlvang3-Nov-06 3:44 
GeneralRe: binary bit manipulation - possible? Pin
neilsolent3-Nov-06 3:49
neilsolent3-Nov-06 3:49 
GeneralRe: binary bit manipulation - possible? Pin
Eric Dahlvang3-Nov-06 5:07
Eric Dahlvang3-Nov-06 5:07 
GeneralRe: binary bit manipulation - possible? Pin
neilsolent3-Nov-06 5:22
neilsolent3-Nov-06 5:22 
QuestionInformix DB Lvarchar(500) Pin
Vipin.d2-Nov-06 17:14
Vipin.d2-Nov-06 17:14 
AnswerRe: Informix DB Lvarchar(500) Pin
Colin Angus Mackay3-Nov-06 0:18
Colin Angus Mackay3-Nov-06 0:18 
QuestionTwo data sources from XML to one DataGridView Pin
kevfoo2-Nov-06 6:42
kevfoo2-Nov-06 6:42 
QuestionORA-01008: not all variables bound - ADO.NET Pin
sri_con32-Nov-06 6:07
sri_con32-Nov-06 6:07 
AnswerRe: ORA-01008: not all variables bound - ADO.NET Pin
Jim Conigliaro2-Nov-06 6:40
Jim Conigliaro2-Nov-06 6:40 
GeneralRe: ORA-01008: not all variables bound - ADO.NET Pin
sri_con33-Nov-06 5:36
sri_con33-Nov-06 5:36 
GeneralRe: ORA-01008: not all variables bound - ADO.NET Pin
sri_con310-Nov-06 1:09
sri_con310-Nov-06 1:09 
QuestionSerious SQL question for MS Access... [modified] Pin
new_phoenix2-Nov-06 5:17
new_phoenix2-Nov-06 5:17 
AnswerRe: Serious SQL question for MS Access... Pin
TheRealRhodieboy3-Nov-06 6:13
TheRealRhodieboy3-Nov-06 6:13 
Questionhow to use logical expressions in mdx query Pin
cellardoor07162-Nov-06 4:53
cellardoor07162-Nov-06 4:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.