The `ntext` data type is deprecated in favour of the `nvarchar(max)` data type. If you can change the data type in the table, that would be the best solution. Then there is no problem comparing it to a `varchar` literal.

Otherwise you would have to cast the value before comparing it:

    cast([ntext2] as nvarchar(max)) &lt;&gt; &#39;1,032.5&#39;

You might also consider using a nvarchar literal, which solves some similar data type problems:

    cast([ntext2] as nvarchar(max)) &lt;&gt; N&#39;1,032.5&#39;


If you would prefer not to cast, you can get by in some scenarios using `LIKE` or `PATINDEX`, as demonstrated on this MSDN thread: http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/6bd4c661-ea0b-435f-af78-097e61549d41

The LIKE expression, without wildcards, would be (in this case) roughly equivalent to a test for equality.

In this case, the expression would be:

    [ntext2] NOT LIKE &#39;1,032.5&#39;

&gt; **Possible Duplicate:**  
&gt; [What are some example use cases for symbol literals in Scala?](https://stackoverflow.com/questions/780287/what-are-some-example-use-cases-for-symbol-literals-in-scala)  

&lt;!-- End of automatically inserted text --&gt;

What&#39;s the purpose of Symbol and why does it deserve some special *literal* syntax e. g. `&#39;FooSymbol`?

Purpose of Scala&#39;s Symbol?

I seem to have something odd with either my Mac 10.6 terminal or my `.vimrc`.

When I type &lt;kbd&gt;backspace&lt;/kbd&gt; on my laptop&#39;s keyboard, it only works when the cursor is at the end of the line. Trying to delete from within a line does nothing. MacVim operates normally. Google hasn&#39;t helped because I can&#39;t even figure out what to call this behavior.

All other backspace commands in my Terminal work as expected, so I am leaning towards it being Vim specific.

Here&#39;s the output of my ~/.vimrc &#39;s mappings, I can&#39;t see anything that would make Vim in the terminal operate this way:

    cflewis@coral-reef ~&gt; egrep &quot;.*map.*&quot; ~/.vimrc 
    &quot;inoremap &lt;expr&gt; &lt;CR&gt; pumvisible() ? &quot;\&lt;C-y&gt;&quot; : &quot;\&lt;C-g&gt;u\&lt;CR&gt;&quot;
    let mapleader = &quot;,&quot;
    map Q gq
    nmap &lt;silent&gt; &lt;leader&gt;s :set nolist!&lt;CR&gt;
    &quot; extended &#39;%&#39; mapping for if/then/else/end etc
    map &lt;S-Insert&gt; &lt;MiddleMouse&gt;
    map! &lt;S-Insert&gt; &lt;MiddleMouse&gt;
    nmap &lt;silent&gt; &lt;C-N&gt; :silent noh&lt;CR&gt;
    nmap &lt;C-E&gt; :b#&lt;CR&gt;
    nmap &lt;C-P&gt; :NERDTreeToggle&lt;CR&gt;
    nmap &lt;leader&gt;p :NERDTreeFind&lt;CR&gt;
    nmap &lt;leader&gt;/ :call NERDComment(0, &quot;invert&quot;)&lt;cr&gt;
    vmap &lt;leader&gt;/ :call NERDComment(0, &quot;invert&quot;)&lt;cr&gt;
    nmap &lt;leader&gt;t :TlistToggle&lt;CR&gt;
    nmap &lt;leader&gt;e :e **/
    nmap &lt;Leader&gt;b :MiniBufExplorer&lt;cr&gt;
    nmap &lt;Leader&gt;sh :ConqueSplit bash&lt;cr&gt;
    nmap &lt;Leader&gt;r :ConqueSplit 
    &quot; map ,y to show the yankring
    nmap &lt;leader&gt;y :YRShow&lt;cr&gt;
    imap &lt;silent&gt; &lt;Down&gt; &lt;C-o&gt;gj
    imap &lt;silent&gt; &lt;Up&gt; &lt;C-o&gt;gk
    nmap &lt;silent&gt; &lt;Down&gt; gj
    nmap &lt;silent&gt; &lt;Up&gt; gk
    cmap w!! %!sudo tee &gt; /dev/null %
    inoremap jj &lt;Esc&gt;
    nnoremap JJJJ &lt;Nop&gt;

Any ideas would be appreciated. I tried flipping the delete key to send ^H or ^?, to no difference.

Mac terminal Vim will only use backspace when at the end of a line

If I use something like

    [ntext2] &lt;&gt; &#39;1,032.5&#39;,

I get this error:

&gt; The data types ntext and varchar are incompatible in the not equal to operator.

The best possible solution would be if comparison is implemented in the same way for any column type. (&lt;&gt; operator is applicable for both NVARCHAR and INT).


What&#39;s the right way to compare an NTEXT column with a constant value?

If I use something like
<pre><code class="hljs language-csharp">[ntext2] &#x3C;> '1,032.5',
</code></pre>
I get this error:
> The data types ntext and varchar are incompatible in the not equal to operator.
The best possible solution would be if comparison is implemented in the same way for any column type. (&#x3C;> operator is applicable for both NVARCHAR and INT).

Could someone give me some guidance on when I should use `WITH (NOLOCK)` as opposed to `SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED`

What are the pros/cons of each?  Are there any unintended consequences you&#39;ve run into using one as opposed to the other?

WITH (NOLOCK) vs SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

I want to alter a table column to be nullable. I have used: 

    ALTER TABLE Merchant_Pending_Functions Modify NumberOfLocations NULL

This gives an error at `Modify`. What is the correct syntax?

Altering a column to be nullable

I want to write reusable code and need to declare some variables at the beginning and reuse them in the script, such as:

    DEFINE stupidvar = &#39;stupidvarcontent&#39;;

    SELECT stupiddata
    FROM stupidtable
    WHERE stupidcolumn = &amp;stupidvar;

How can I declare a variable and reuse it in statements that follow such as in using it SQLDeveloper.

---

**Attempts**

*  Use a DECLARE section and insert the following SELECT statement in `BEGIN` and `END;`. Acces the variable using `&amp;stupidvar`.
*  Use the keyword `DEFINE` and access the variable.
* Using the keyword `VARIABLE` and access the the variable.

But I am getting all kinds of errors during my tries (Unbound variable, Syntax error, Expected `SELECT INTO`...).

How to declare variable and use it in the same Oracle SQL script?

I am trying to execute a SQlite replace function, but use another field in the function.

    select  locationname + &#39;&lt;p&gt;&#39; from location;

In this snip, the result is a list of 0s. I would have expected   a string with the text from locationname and the `&#39;&lt;p&gt;&#39;` literals.



String concatenation does not work in SQLite

I am looking for the syntax to add a column to a MySQL database with a default value of 0 

[Reference][1]


  [1]: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

Adding a new SQL column with a default value

As a .NET developer, for what reasons should I prefer SSIS packages over writing code? We have *a ton* of packages in production where I currently work, and they&#39;re a nightmare to both &quot;write&quot; (perhaps draw?) and maintain. Each package looks like a bowl of multicolored spaghetti with C# and VB.NET scripts mixed in at the points where the abstractions break down. To figure out what each &quot;Execute SQL Task&quot; or &quot;Foreach Loop&quot; does, I have to double click the damned thing and browse through a tree of literal values and expressions, scattered across multiple tabs.

I&#39;m open minded, so I&#39;d like to know if any other *good developers* find SSIS more productive than just writing some code. If you do find SSIS more productive, please tell me why.

Should programmers use SSIS, and if so, why?

How can I call stored procedures of sql server with sqlAlchemy?

stored procedures with sqlAlchemy

I have the following string

    &#225;&#233;&#237;&#243;&#250;

which I need to convert it to

    aeiou

How can I achieve it? (I don&#39;t need to compare, I need the new string to save)

How can I remove accents on a string?

I&#39;m thinking about how to represent a complex structure in a SQL Server database.

Consider an application that needs to store details of a family of objects, which share some attributes, but have many others not common. For example, a commercial insurance package may include liability, motor, property and indemnity cover within the same policy record.

It is trivial to implement this in C#, etc, as you can create a Policy with a collection of Sections, where Section is inherited as required for the various types of cover. However, relational databases don&#39;t seem to allow this easily.

I can see that there are two main choices:

 1. Create a Policy table, then a Sections table, with all the fields required, for all possible variations, most of which would be null.  
 
 3. Create a Policy table and numerous Section tables, one for each kind of cover.

Both of these alternatives seem unsatisfactory, especially as it is necessary to write queries across all Sections, which would involve numerous joins, or numerous null-checks.

What is the best practice for this scenario?

How can you represent inheritance in a database?

Is there a way to get the SQL text for the last few queries?

I am using Microsoft SQL Server 2005

TSQL: Get Last Queries Ran

Can someone explain this two - Index Key Column VS Index Included Column?

Currently, I have an index that has 4 Index Key Column and 0 Included Column.

Thanks



Index Key Column VS Index Included Column

I found [Naming Guidelines][1] from MSDN, but is it any guideline for MSSQL database from Microsoft? 


  [1]: http://msdn.microsoft.com/en-us/library/ms229045.aspx

Database Naming Conventions by Microsoft?

Need to duplicate a TABLE using `Microsoft SQL Management Studio 2008`

The TABLE needs to duplicate all table row (Primary Key) ID as well.


Duplicating a TABLE using Microsoft SQL Server Management

I have a table and I need to retrieve the ID of the Second row. How to achieve that ?

 By `Top 2` I select the two first rows, but I need **only** the second row

Content Type	Original Author	Original Content on Stackoverflow
Question	noober	View Question on Stackoverflow
Solution 1 - Sql	Guffa	View Answer on Stackoverflow
Solution 2 - Sql	kbrimington	View Answer on Stackoverflow

What's the right way to compare an NTEXT column with a constant value?

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Mac terminal Vim will only use backspace when at the end of a line

Purpose of Scala's Symbol?

Attributions