Can someone assist with writing this query? Thank you!
I think I am writing this incorrect somewhere however cannot see it so getting some other eyes on it. If you re-write the query please do from beginning to end because it gets confusing at times.
I think the bold s incorrect however with little sleep I am having trouble. Thanks guys.
use test
go
update testtable
set isdelted = convert(varchar(32), 0x31)
where testcolum in ( 'value', 'value', 'value')
Hi @DBAEng,
what is the data type used for isdelted column and to what value (
convert(varchar(32), 0x31) ..........????
) are you trying to update it.
I'm having to guess here because its not clear what you're trying to do.
I think your trying to set a BIT column to 1 where your testcolumn is a certain value.
Either use:
SET IsDelted = 1
or
SET IsDelted = CHAR(0x31)
