There is no difference. You can use both in MSSQL.

[The MSSQL doc says:][1]

&gt; `!=` functions the same as the `&lt;&gt;` (Not Equal To) comparison operator.

But `&lt;&gt;` is defined in the [ANSI 99 SQL standard][2] and `!=` is not. So not all DB engines may support it and if you want to generate portable code I recommend using `&lt;&gt;`.


  [1]: http://msdn.microsoft.com/en-us/library/ms190296.aspx
  [2]: http://web.cecs.pdx.edu/~len/sql1999.pdf

Most of the databases support both `!=` and `&lt;&gt;` as *not equal* comparison operators. `&lt;&gt;` means either less than or greater than (i.e. not equal to) and was introduced because not all the keyboards used to have the exclamation `!` key (a long time ago). Some databases like Oracle also support `^=` for *not equals*.

I&#39;m trying to get pygobject-2.28.6 to compile in cygwin (version in repository is 2.28.4 which has some issues). Here is the tail of ./configure:

	checking for GLIB - version &gt;= 2.24.0... yes (version 2.34.3)
	checking for ffi... checking for FFI... yes
	checking for GIO... yes
	checking for GIOUNIX... yes
	checking for GI... no
	configure: error: Package requirements (glib-2.0 &gt;= 2.24.0
			gobject-introspection-1.0 &gt;= 0.10.2
		) were not met:

	No package &#39;gobject-introspection-1.0&#39; found

	Consider adjusting the PKG_CONFIG_PATH environment variable if you
	installed software in a non-standard prefix.

	Alternatively, you may set the environment variables GI_CFLAGS
	and GI_LIBS to avoid the need to call pkg-config.
	See the pkg-config man page for more details.

I have gobject-introspection 1.34.2-3 installed. As seen here:

	$ whereis gobject-introspection
	gobject-introspection: /lib/gobject-introspection /usr/lib/gobject-introspection

and here

	$ whereis gobject-introspection-1.0
	gobject-introspection-1: /usr/share/gobject-introspection-1.0

I&#39;ve tried setting GI_CFLAGS and GI_LIBS in configure = to /lib/ and /usr/lib/ (and even /usr/share/) but to no avail. What else can I do to try and resolve this? Thank you for your time!

pygobject-2.28.6 won&#39;t configure: No package &#39;gobject-introspection-1.0&#39; found, how do I resolve?

I am trying to rename files from foobar.php to FooBar.php which is quite a challenge in Git. So far I have found out that I had to set up the git config value of `ignorecase` to `false` (why it was set to true on Mac OS X, anyway?). I have managed to rename those files successfully in my local repository, but after I pushed it to BitBucket I&#39;ve got `FooBar.php` as well as `foobar.php` there. How do I get rid of these duplicates? Thanks.

Duplicated file with different case in git origin (bitbucket)

What is difference between `!=` and `&lt;&gt;` operators in Sql Server? 

Since both are used as `not` operator. E.g :

    select * from TableName where ColName &lt;&gt; value

or 

    select * from TableName where ColName != value

returns same values (Rows).


What is difference between != and &lt;&gt; in sql server

What is difference between <code>!=</code> and <code>&#x3C;></code> operators in Sql Server?
Since both are used as <code>not</code> operator. E.g :
<pre><code class="hljs language-csharp">select * from TableName where ColName &#x3C;> value
</code></pre>
or
<pre><code class="hljs language-csharp">select * from TableName where ColName != value
</code></pre>
returns same values (Rows).

Looking for elegant (or any) solution to convert columns to rows.

Here is an example: I have a table with the following schema:

    [ID] [EntityID] [Indicator1] [Indicator2] [Indicator3] ... [Indicator150]

Here is what I want to get as the result:

    [ID] [EntityId] [IndicatorName] [IndicatorValue]

And the result values will be:

    1 1 &#39;Indicator1&#39; &#39;Value of Indicator 1 for entity 1&#39;
    2 1 &#39;Indicator2&#39; &#39;Value of Indicator 2 for entity 1&#39;
    3 1 &#39;Indicator3&#39; &#39;Value of Indicator 3 for entity 1&#39;
    4 2 &#39;Indicator1&#39; &#39;Value of Indicator 1 for entity 2&#39;

And so on..

Does this make sense? Do you have any suggestions on where to look and how to get it done in T-SQL? 

SQL Server : Columns to Rows

&gt; The ORDER BY clause is invalid in views, inline functions, derived
&gt; tables, subqueries, and common table expressions, unless TOP, OFFSET
&gt; or FOR XML is also specified.

I am getting the above said error while trying to execute the following query. Can anyone please have a look and tell me what am I doing wrong here?

	SELECT 
		* 
	FROM (
		SELECT 
			Stockmain.VRNOA, 
			item.description as item_description, 
			party.name as party_name, 
			stockmain.vrdate, 
			stockdetail.qty, 
			stockdetail.rate, 
			stockdetail.amount, 
			ROW_NUMBER() OVER (ORDER BY VRDATE) AS RowNum
		FROM StockMain 
		INNER JOIN StockDetail 
			ON StockMain.stid = StockDetail.stid 
		INNER JOIN party 
			ON party.party_id = stockmain.party_id 
		INNER JOIN item 
			ON item.item_id = stockdetail.item_id 
		WHERE stockmain.etype=&#39;purchase&#39; 
		ORDER BY VRDATE DESC
	) AS MyDerivedTable
	WHERE 
		MyDerivedTable.RowNum BETWEEN 1 and 5	

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions

How can I get the SQL Server server and instance name of the current connection, using a T-SQL script?

How to get current instance name from T-SQL

I&#39;ve created a UDF that accesses the `[INFORMATION_SCHEMA].[TABLES]` view:

	CREATE FUNCTION [dbo].[CountTables]
	(
		@name sysname
	)
	RETURNS INT
	AS
	BEGIN
		RETURN
		(
			SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = @name
		);
	END

Within Visual Studio, the schema and name for the view are both marked with a warning:

&gt;SQL71502: Function: [dbo].[CountTables] has an unresolved reference to object [INFORMATION_SCHEMA].[TABLES].

I can still publish the database project without any problems, and the UDF does seem to run correctly. IntelliSense populates the name of the view for me, so it doesn&#39;t seem to have a problem with it.

I also tried changing the implementation to use `sys.objects` instead of this view, but I was given the same warning for this view as well.

How can I resolve this warning?


unresolved reference to object [INFORMATION_SCHEMA].[TABLES]

I have trouble querying a table of &gt; 5 million records from MS SQL Server database. I want to select all of the records, but my code seems to fail when selecting to much data into memory. 

   
This works:
    
    import pandas.io.sql as psql
    sql = &quot;SELECT TOP 1000000 * FROM MyTable&quot; 
    data = psql.read_frame(sql, cnxn)

...but this does not work:
    
    sql = &quot;SELECT TOP 2000000 * FROM MyTable&quot; 
    data = psql.read_frame(sql, cnxn)

It returns this error:

    File &quot;inference.pyx&quot;, line 931, in pandas.lib.to_object_array_tuples
    (pandas\lib.c:42733) Memory Error

I have read [here][1] that a similar problem exists when creating a `dataframe` from a csv file, and that the work-around is to use the &#39;iterator&#39; and &#39;chunksize&#39; parameters like this:

    read_csv(&#39;exp4326.csv&#39;, iterator=True, chunksize=1000)

Is there a similar solution for querying from an SQL database?  If not, what is the preferred work-around?  Should I use some other methods to read the records in chunks?  I read a bit of discussion [here][2] about working with large datasets in pandas, but it seems like a lot of work to execute a SELECT * query.  Surely there is a simpler approach.


  [1]: https://stackoverflow.com/questions/11622652/large-persistent-dataframe-in-pandas
  [2]: https://stackoverflow.com/questions/14262433/large-data-work-flows-using-pandas

How to create a large pandas dataframe from an sql query without running out of memory?

I get the following error when trying to connect to SQL Server:


&gt; A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

This error is thrown when I try to configure my database to gridview in Visual Studio 2010. I&#39;m at a loss as to how to debug this error.

How would you debug this error? What steps should I take in order to determine what is really going on here, in addition to the one mentioned in the error message?

Cannot Connect to Server - A network-related or instance-specific error

Consider the following snippet:

    &quot;12-18&quot; -Contains &quot;-&quot;

You’d think this evaluates to `true`, but it doesn&#39;t. This will evaluate to `false` instead. I’m not sure why this happens, but it does.

To avoid this, you can use this instead:

    &quot;12-18&quot;.Contains(&quot;-&quot;)

Now the expression will evaluate to true.

Why does the first code snippet behave like that? Is there something special about `-` that doesn&#39;t play nicely with `-Contains`? [The documentation][1] doesn&#39;t mention anything about it.

  [1]: http://technet.microsoft.com/en-us/library/hh847759.aspx


PowerShell and the -contains operator

In maths, if I wish to calculate 3 to the power of 2 then no symbol is required, but I write the 2 small: `3&#178;`. In Python this operation seems to be represented by the `**` syntax.

    &gt;&gt;&gt; 3**2
    9

If I want to go the other direction and calculate the 2nd root of 9 then in maths I need to use a symbol: `2√9 = 3`

Is there a short-hand symbol in Python, similar to `**` that achieves this i.e. `2&lt;symbol&gt;9`? Or do I need to use the `math` module?

Is there a short-hand for nth root of x in Python?

When you are writing slightly more complex functions I notice that `$` is used a lot but I don&#39;t have a clue what it does?

What does $ mean/do in Haskell?

I&#39;ve been working with JavaScript for a few days now and have got to a point where I want to overload operators for my defined objects.

After a stint on google searching for this it seems you can&#39;t officially do this, yet there are a few people out there claiming some long-winded way of performing this action.

Basically I&#39;ve made a Vector2 class and want to be able to do the following:

    var x = new Vector2(10,10);
    var y = new Vector2(10,10);
    
    x += y; //This does not result in x being a vector with 20,20 as its x &amp; y values.

Instead I&#39;m having to do this:
  
    var x = new Vector2(10,10);
    var y = new Vector2(10,10);

    x = x.add(y); //This results in x being a vector with 20,20 as its x &amp; y values. 

Is there an approach I can take to overload operators in my Vector2 class? As this just looks plain ugly.
     

Javascript: operator overloading

What is the difference between the `&amp;&amp;`, `||`, `-a`, and `-o` Unix operators?

What are the restrictions on the usage of both types?

Is it simply that the `&amp;&amp;` and `||` operators should be used when using flags in the condition?

As in:

    [ &quot;$1&quot; = &quot;yes&quot; ] &amp;&amp; [ -r $2.txt ]

versus:

    [ &quot;$1&quot; = &quot;yes&quot; -a $2 -lt 3 ]


Content Type	Original Author	Original Content on Stackoverflow
Question	Ankush Madankar	View Question on Stackoverflow
Solution 1 - Sql	juergen d	View Answer on Stackoverflow
Solution 2 - Sql	Ravi K Thapliyal	View Answer on Stackoverflow

What is difference between != and <> in sql server

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Duplicated file with different case in git origin (bitbucket)

pygobject-2.28.6 won't configure: No package 'gobject-introspection-1.0' found, how do I resolve?

Attributions