How to turn from Access to Microsoft SQL statement

Customer Support Database Support
1

Hi
I am developing a program that can work with Access or Microsoft SQL server. I used different syntax for SQL statements. It works fine with Access. When i try with msSQL i got one problem that i don’t know how to solve.I use one column - yes/no type and when i import tables to msSQL database,the column turns to bit type(0 or 1 values). When i want to update at msSQL, I can’t use the “NOT” as i use in Access in below statement.

UPDATE Table
SET Column = NOT Column
WHERE (ID = 1);

I found online but can’t find that topic.
Really appreciate the help!

2

[QUOTE=ki ki]
Hi
UPDATE Table
SET Column = NOT Column
WHERE (ID = 1);

I found online but can’t find that topic.
Really appreciate the help!
[/QUOTE]

You have to change all your SQL statements to use “1” instead of “true” and “0” instead of “false”.

3

You should be able to use Column = ~ Column on MS SQL.
(~ is the binary NOT operator)

4

Thanks a lot subspace. :wink: i use ~ and it works. I really appreciate ur help. Thanks to Logan too. :))