Yes, the ~ operator will work.

    update foo
    set Sync = ~@IsNew


**Bitwise NOT: ~**

Bitwise AND: &amp;

Bitwise OR:  |

Bitwise XOR: ^


Lacking on MSDN?
&lt;http://msdn.microsoft.com/en-us/library/ms173468(SQL.90).aspx&gt;

&gt; ~: Performs a bitwise logical NOT operation on an integer value.
The ~ bitwise operator performs a bitwise logical NOT for the expression, taking each bit in turn. If expression has a value of 0, the bits in the result set are set to 1; otherwise, the bit in the result is cleared to a value of 0. In other words, ones are changed to zeros and zeros are changed to ones.

For the sake of completeness:

    SELECT b, 1 - b
    FROM
      (SELECT cast(1 AS BIT) AS b
       UNION ALL
       SELECT cast(0 AS BIT) AS b) sampletable



 ~ operator will work only with BIT,

try:
 ~ CAST(@IsNew AS BIT)

The array has lots of data and I need to delete two elements. 

Below is the code snippet I am using,

    my @array = (1,2,3,4,5,5,6,5,4,9);
    my $element_omitted = 5;
    @array = grep { $_ != $element_omitted } @array;



What is the best way to delete a value from an array in Perl?

I have seen a few mentions of this idiom (including [on SO][1]):

    // Deliberately empty subscriber
    public event EventHandler AskQuestion = delegate {};

The upside is clear - it avoids the need to check for null before raising the event.

**However, I am keen to understand if there are any downsides.**  For example, is it something that is in widespread use and is transparent enough that it won&#39;t cause a maintenance headache?  Is there any appreciable performance hit of the empty event subscriber call?


  [1]: https://stackoverflow.com/questions/9033/hidden-features-of-c#9282

Is there a downside to adding an anonymous empty delegate on event declaration?

I&#39;m trying to perform a bitwise NOT in SQL Server. I&#39;d like to do something like this:

    update foo
    set Sync = NOT @IsNew

Note: I started writing this and found out the answer to my own question before I finished. I still wanted to share with the community, since this piece of documentation was lacking on MSDN (until I added it to the Community Content there, too).

How do I flip a bit in SQL Server?

I'm trying to perform a bitwise NOT in SQL Server. I'd like to do something like this:
<pre><code class="hljs language-sql">update foo
set Sync = NOT @IsNew
</code></pre>
Note: I started writing this and found out the answer to my own question before I finished. I still wanted to share with the community, since this piece of documentation was lacking on MSDN (until I added it to the Community Content there, too).

Which of these queries is the faster?

NOT EXISTS:

    SELECT ProductID, ProductName 
    FROM Northwind..Products p
    WHERE NOT EXISTS (
        SELECT 1 
        FROM Northwind..[Order Details] od 
        WHERE p.ProductId = od.ProductId)

Or NOT IN:

    SELECT ProductID, ProductName 
    FROM Northwind..Products p
    WHERE p.ProductID NOT IN (
        SELECT ProductID 
        FROM Northwind..[Order Details])

The query execution plan says they both do the same thing.  If that is the case, which is the recommended form?

This is based on the NorthWind database.


[Edit]

Just found this helpful article: 
http://weblogs.sqlteam.com/mladenp/archive/2007/05/18/60210.aspx

I think I&#39;ll stick with NOT EXISTS.

NOT IN vs NOT EXISTS

If I wish to simply rename a column (not change its type or constraints, just its name) in an SQL database using SQL, how do I do that?  Or is it not possible?

This is for any database claiming to support SQL, I&#39;m simply looking for an SQL-specific query that will work regardless of actual database implementation.

How do I rename a column in a database table using SQL?

My database contains three tables called `Object_Table`, `Data_Table` and `Link_Table`. The link table just contains two columns, the identity of an object record and an identity of a data record.

I want to copy the data from `DATA_TABLE` where it is linked to one given object identity and insert corresponding records into `Data_Table` and `Link_Table` for a different given object identity.

I **can** do this by selecting into a table variable and the looping through doing two inserts for each iteration.

Is this the best way to do it?

**Edit** : I want to avoid a loop for two reason, the first is that I&#39;m lazy and a loop/temp table requires more code, more code means more places to make a mistake and the second reason is a concern about performance.

I can copy all the data in one insert but how do get the link table to link to the new data records where each record has a new id?

SQL Server: Is it possible to insert into two tables at the same time?

How do you prepare your SQL deltas? do you manually save each schema-changing SQL to a delta folder, or do you have some kind of an automated diffing process?

I am interested in conventions for versioning database schema along with the source code. Perhaps a pre-commit hook that diffs the schema?

Also, what options for diffing deltas exist aside from [DbDeploy][1]?

**EDIT:** seeing the answers I would like to clarify that I am familiar with the standard scheme for running a database migration using deltas. My question is about creating the deltas themselves, preferably automatically.

Also, the versioning is for PHP and MySQL if it makes a difference. (No Ruby solutions please).

  [1]: http://dbdeploy.com/

How do you version your database schema?

How can I have a dynamic variable setting the amount of rows to return in SQL Server? Below is not valid syntax in SQL Server 2005+:

    DECLARE @count int
    SET @count = 20
    
    SELECT TOP @count * FROM SomeTable



Dynamic SELECT TOP @var In SQL Server

In SQL Server 2005, is there a way of deleting rows and being told how many were **actually** deleted? 

I could do a `select count(*)` with the same conditions, but I need this to be utterly trustworthy.  

My first guess was to use the `@@ROWCOUNT` variables - but that isn&#39;t set, e.g. 

    delete 
    from mytable 
    where datefield = &#39;5-Oct-2008&#39; 

    select @@ROWCOUNT 

always returns a 0. 


MSDN suggests the [`OUTPUT`][1] construction, e.g. 

    delete from mytable 
    where datefield = &#39;5-Oct-2008&#39; 
    output datefield into #doomed

    select count(*) 
    from #doomed

this actually fails with a syntax error. 

Any ideas? 


  [1]: http://msdn.microsoft.com/en-us/library/ms189835.aspx



Counting the number of deleted rows in a SQL Server stored procedure

What is the best way to get the names of all of the tables in a specific database on SQL Server?

How do I get list of all tables in a database using TSQL?

What are they and how do they work?

Context happens to be SQL Server

What are named pipes?

Can someone explain to me how XOR swapping of two variables with no temp variable works?

    void xorSwap (int *x, int *y)
    {
        if (x != y) {
            *x ^= *y;
            *y ^= *x;
            *x ^= *y;
        }
    }

I understand WHAT it does, but can someone walk me through the logic of how it works?  

How does XOR variable swapping work?

I want to write a function that returns the nearest next power of 2 number. For example if my input is 789, the output should be 1024. Is there any way of achieving this without using any loops but just using some bitwise operators?

Rounding up to next power of 2

Have you ever had to use [bit shifting][1] in real programming projects? Most (if not all) high level languages have shift operators in them, but when would you actually need to use them?


  [1]: http://en.wikipedia.org/wiki/Bit_shift#Bit_shifts

Have you ever had to use bit shifting in real projects?

    int temp = 0x5E; // in binary 0b1011110.

Is there such a way to check if bit 3 in temp is 1 or 0 without bit shifting and masking.

Just want to know if there is some built in function for this, or am I forced to write one myself.

     

C/C++ check if one bit is set in, i.e. int variable

I often use `($var &amp; 1)` in my code, which returns true if `$var` is an odd number and false if it&#39;s an even number.

But what does &quot;&amp;&quot; actually do?


Content Type	Original Author	Original Content on Stackoverflow
Question	Even Mien	View Question on Stackoverflow
Solution 1 - Sql	Jason Kresowaty	View Answer on Stackoverflow
Solution 2 - Sql	Even Mien	View Answer on Stackoverflow
Solution 3 - Sql	Blorgbeard	View Answer on Stackoverflow
Solution 4 - Sql	Oliver	View Answer on Stackoverflow
Solution 5 - Sql	vitik	View Answer on Stackoverflow

How do I flip a bit in SQL Server?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

Solution 4 - Sql

Solution 5 - Sql

Is there a downside to adding an anonymous empty delegate on event declaration?

What is the best way to delete a value from an array in Perl?

Attributions