    WHERE NOT (someColumn LIKE &#39;%Apples%&#39;)

Or alternatively, you could use this:

    WHERE CHARINDEX(N&#39;Apples&#39;, someColumn) = 0

Not sure which one performs better - you gotta test it! :-)

Marc

UPDATE: the performance seems to be pretty much on a par with the other solution (WHERE someColumn NOT LIKE &#39;%Apples%&#39;) - so it&#39;s really just a question of your personal preference.

Use this as your WHERE condition

    WHERE CHARINDEX(&#39;Apples&#39;, column) = 0 

The answers you got assumed static text to compare against.  If you want to compare against another column (say, you&#39;re joining two tables, and want to find ones where a column from one table is part of a column from another table), you can do this

    WHERE NOT (someColumn LIKE &#39;%&#39; || someOtherColumn || &#39;%&#39;)




I have a Ruby CGI (not rails) that picks photos and captions from a web form. My users are very keen on using smart quotes and ligatures, they are pasting from other sources. My web app does not deal well with these non-ASCII characters, is there a quick Ruby string manipulation routine that can get rid of non-ASCII chars?


How to get rid of non-ascii characters in ruby

I&#39;m trying to disassemble a program to see a syscall assembly instruction (the INT instruction, I believe) and the handler with GDB and have written a little program (see below) for it that opens and closes a file.

I was able to follow the call to fopen with GDB until it executed a call.

When I tried to tell GDB &quot;disassemble 0x....&quot; (address of call) it responded with &#39;No function contains specified address.&#39;

Is it possible to force GDB to disassemble (or display it in assembler as good as possible) that memory address? If so, how? 

    #include &lt;stdio.h&gt;
    #include &lt;stdlib.h&gt;
    
    int main() {
    	FILE* f;
    	f = fopen(&quot;main.c&quot;, &quot;r&quot;);
    	if (!f) { 
    	  perror(&quot;open&quot;);
    	  return -1;
    	}
	    fclose(f);
	    return 0;
    }

How to disassemble a memory range with GDB?

In T-SQL, how would you check if a string doesn&#39;t contain another string?

I have an `nvarchar` which could be &quot;Oranges Apples&quot;.

I would like to do an update where, for instance, a columm *doesn&#39;t* contain &quot;Apples&quot;. 

How can this be done?

Check if string doesn&#39;t contain another string

In T-SQL, how would you check if a string doesn't contain another string?
I have an <code>nvarchar</code> which could be "Oranges Apples".
I would like to do an update where, for instance, a columm doesn't contain "Apples".
How can this be done?

I am using SQL Server 2008 Enterprise. I want to see any active SQL Server connections, and the related information of all the connections, like from which IP address, connect to which database or something.

Are there existing commands to solve this issue?


How do I see active SQL Server connections?

What is a trusted connection in terms of SQL Server 2005 (Trusted vs Windows Auth)?

What is a Trusted Connection?

I have a limited exposure to DB and have only used DB as an application programmer. I want to know about `Clustered` and `Non clustered indexes`.
I googled and what I found was :

&gt; *A clustered index is a special type of index that reorders  the way
&gt; records in the table are physically
&gt; stored.  Therefore table can have only
&gt; one clustered index. The leaf  nodes
&gt; of a clustered index contain the data
&gt; pages. A nonclustered index is a
&gt; special type of index in which  the
&gt; logical order of the index does not
&gt; match the physical  stored order of
&gt; the rows on disk. The leaf node of a 
&gt; nonclustered index does not consist of
&gt; the data pages.  Instead, the leaf
&gt; nodes contain index rows.*

What I found in SO was [https://stackoverflow.com/questions/91688/what-are-the-differencespros-cons-between-clustered-and-non-clustered-indexes][1].

Can someone explain this in plain English?


  [1]: https://stackoverflow.com/questions/91688/what-are-the-differencespros-cons-between-clustered-and-non-clustered-indexes

What do Clustered and Non-Clustered index actually mean?

How do I remove the last character in a string in `T-SQL`?

For example:

    &#39;TEST STRING&#39;

to return:

    &#39;TEST STRIN&#39;



Remove the last character in a string in T-SQL?

I want to execute this stored procedure from a C# program.

I have written the following stored procedure in a SqlServer query window and saved it as 
stored1:
     
    use master 
    go
    create procedure dbo.test as

    DECLARE @command as varchar(1000), @i int
    SET @i = 0
    WHILE @i &lt; 5
    BEGIN
    Print &#39;I VALUE &#39; +CONVERT(varchar(20),@i)
    EXEC(@command)
    SET @i = @i + 1
    END

&lt;b&gt;EDITED:&lt;/b&gt;
       
    using System;
    using System.Collections.Generic;
    using System.Text;
    using System.Data;
    using System.Data.SqlClient;
    namespace AutomationApp
    {
        class Program
        {
            public void RunStoredProc()
            {
                SqlConnection conn = null;
                SqlDataReader rdr  = null;

                Console.WriteLine(&quot;\nTop 10 Most Expensive Products:\n&quot;);

                try
                {
                    conn = new SqlConnection(&quot;Server=(local);DataBase=master;Integrated Security=SSPI&quot;);
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(&quot;dbo.test&quot;, conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    rdr = cmd.ExecuteReader();
                    /*while (rdr.Read())
                    {
                        Console.WriteLine(
                            &quot;Product: {0,-25} Price: ${1,6:####.00}&quot;,
                            rdr[&quot;TenMostExpensiveProducts&quot;],
                            rdr[&quot;UnitPrice&quot;]);
                    }*/
                }
                finally
                {
                    if (conn != null)
                    {
                        conn.Close();
                    }
                    if (rdr != null)
                    {
                        rdr.Close();
                    }
                }
            }
            static void Main(string[] args)
            {
                Console.WriteLine(&quot;Hello World&quot;);
                Program p= new Program();
                p.RunStoredProc();		
                Console.Read();
            }
        }
    }

This displays the exception `Cannot find the stored procedure dbo.test`. Do I need to provide the path? If yes, in which location should the stored procedures be stored?

How to execute a stored procedure within C# program

I&#39;m trying to go through our development DB right now and clean up some of the old test procs/tables. Is it possible to determine what user created objects in a SQL Server 2005 database? If so, how would I go about finding that information?

Edit: Just wanted to clarify that the objects in question already exist. Setting up auditing and triggers probably wouldn&#39;t do me much good. I guess I was mostly looking for a way to use the system tables/views to get to the information.

Determine what user created objects in SQL Server

The situation is you have a value in Seconds (XXX.XX), and you want to convert to HH:MM:SS using T-SQL.

Example:

 - 121.25 s becomes 00:02:01.25

How to convert Seconds to HH:MM:SS using T-SQL

Trying to parameterize the value of TOP in my sql statement. 

    SELECT TOP @topparam * from table1

    command.Parameters.Add(&quot;@topparam&quot;,SqlDbType.VarChar, 10).Value = somevalue.ToString();

This doesn&#39;t seem to work. Anyone have any suggestions?  
Just to clarify, I don&#39;t want to use stored procedures. 

C# SQL Top as parameter

When and Why does some one decide that they need to create a View in their database?  Why not just run a normal stored procedure or select?

Why do you create a View in a database?

Using the following code:

    char *name = malloc(sizeof(char) + 256); 

	printf(&quot;What is your name? &quot;);
	scanf(&quot;%s&quot;, name);
	
	printf(&quot;Hello %s. Nice to meet you.\n&quot;, name);

A user can enter their name but when they enter a name with a space like `Lucas Aardvark`, `scanf()` just cuts off everything after `Lucas`. How do I make `scanf()` allow spaces

How do you allow spaces to be entered using scanf?

I am using Java NIO for my socket connections, and my protocol is text based, so I need to be able to convert Strings to ByteBuffers before writing them to the SocketChannel, and convert the incoming ByteBuffers back to Strings.  Currently, I am using this code:

    public static Charset charset = Charset.forName(&quot;UTF-8&quot;);
    public static CharsetEncoder encoder = charset.newEncoder();
    public static CharsetDecoder decoder = charset.newDecoder();
    
    public static ByteBuffer str_to_bb(String msg){
      try{
        return encoder.encode(CharBuffer.wrap(msg));
      }catch(Exception e){e.printStackTrace();}
      return null;
    }
    
    public static String bb_to_str(ByteBuffer buffer){
      String data = &quot;&quot;;
      try{
        int old_position = buffer.position();
        data = decoder.decode(buffer).toString();
        // reset buffer&#39;s position to its original so it is not altered:
        buffer.position(old_position);	
      }catch (Exception e){
        e.printStackTrace();
        return &quot;&quot;;
      }
      return data;
    }

This works most of the time, but I question if this is the preferred (or simplest) way to do each direction of this conversion, or if there is another way to try.  Occasionally, and seemingly at random, calls to `encode()` and `decode()` will throw a 
`java.lang.IllegalStateException: Current state = FLUSHED, new state = CODING_END` exception, or similar, even if I am using a new ByteBuffer object each time a conversion is done.  Do I need to synchronize these methods?  Any better way to convert between Strings and ByteBuffers?  Thanks!


Java: Converting String to and from ByteBuffer and associated problems

I want a version of `str_replace()` that only replaces the first occurrence of `$search` in the `$subject`. Is there an easy solution to this, or do I need a hacky solution?

Using str_replace so that it only acts on the first match?

Is there any way to use raw strings in Java (without escape sequences)?

(I&#39;m writing a fair amount of regex code and raw strings would make my code immensely more readable)

I understand that the language does not provide this directly, but is there any way to &quot;simulate&quot; them in any way whatsoever?

Raw Strings in Java - for regex in particular. Multiline strings

I need to replace Microsoft Word&#39;s version of single and double quotations marks (`“ ” ‘ ’`) with regular quotes (&#39; and &quot;) due to an encoding issue in my application. I do not need them to be HTML entities and I cannot change my database schema.

I have two options: to use either a regular expression or an associated array.

Is there a better way to do this?


Content Type	Original Author	Original Content on Stackoverflow
Question	Dofs	View Question on Stackoverflow
Solution 1 - Sql Server	Daniel A. White	View Answer on Stackoverflow
Solution 2 - Sql Server	marc_s	View Answer on Stackoverflow
Solution 3 - Sql Server	dutch	View Answer on Stackoverflow
Solution 4 - Sql Server	Greg Dougherty	View Answer on Stackoverflow

Check if string doesn't contain another string

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

How to disassemble a memory range with GDB?

How to get rid of non-ascii characters in ruby

Attributions