In SQL Server **2012**, you could use the [`IIF` function][1]:

    SELECT *
    FROM table
    WHERE isExternal = IIF(@type = 2, 1, 0)

Also note: in T-SQL, the assignment (and comparison) operator is just `=` (and not `==` - that&#39;s C#)


  [1]: https://docs.microsoft.com/en-us/sql/t-sql/functions/logical-functions-iif-transact-sql

Use `case`:

    select *
    from table
    where isExternal = case @type when 2 then 1 else 0 end


I have a favicon icon which isn&#39;t showing up in Chrome (I&#39;m not sure about other browsers as I only use Chrome) but the strange thing is if I type the path to the icon in the URL bar it shows up!

Why doesn&#39;t the icon appear?

Favicon not showing up in Google Chrome

I&#39;d like to create a `colorbar` legend for a `heatmap`, such that the labels are in the center of each discrete color. [Example borrowed from here][1]:

    import matplotlib.pyplot as plt
    import numpy as np
    from matplotlib.colors import ListedColormap

    #discrete color scheme
    cMap = ListedColormap([&#39;white&#39;, &#39;green&#39;, &#39;blue&#39;,&#39;red&#39;])

    #data
    np.random.seed(42)
    data = np.random.rand(4, 4)
    fig, ax = plt.subplots()
    heatmap = ax.pcolor(data, cmap=cMap)

    #legend
    cbar = plt.colorbar(heatmap)
    cbar.ax.set_yticklabels([&#39;0&#39;,&#39;1&#39;,&#39;2&#39;,&#39;&gt;3&#39;])
    cbar.set_label(&#39;# of contacts&#39;, rotation=270)

    # put the major ticks at the middle of each cell
    ax.set_xticks(np.arange(data.shape[1]) + 0.5, minor=False)
    ax.set_yticks(np.arange(data.shape[0]) + 0.5, minor=False)
    ax.invert_yaxis()

    #labels
    column_labels = list(&#39;ABCD&#39;)
    row_labels = list(&#39;WXYZ&#39;)
    ax.set_xticklabels(column_labels, minor=False)
    ax.set_yticklabels(row_labels, minor=False)

    plt.show()

This generates the following plot:

[![pmesh plot][2]][2]

Ideally I&#39;d like to generate a legend bar which has the four colors and for each color, a label in its center: `0,1,2,&gt;3`. How can this be achieved?

  [1]: https://stackoverflow.com/questions/14406214/moving-x-axis-to-the-top-of-a-plot-in-matplotlib
  [2]: http://i.stack.imgur.com/v07GA.png

matplotlib: colorbars and its text labels

What are alternatives to implement the following query:

    select *  
    from table  
    where isExternal = @type = 2 ? 1 : 0

Is there a ternary conditional operator in T-SQL?

What are alternatives to implement the following query:
<pre><code class="hljs language-sql">select * 
from table 
where isExternal = @type = 2 ? 1 : 0
</code></pre>

How to find third or n&lt;sup&gt;th&lt;/sup&gt; maximum salary from salary `table(EmpID, EmpName, EmpSalary)` in optimized way?


How to find third or nᵗʰ maximum salary from salary table?

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL.

    ALTER TABLE table_name RENAME COLUMN old_name to new_name;

This statement doesn&#39;t work.



Rename column SQL Server 2008

I have a query like this:

    SELECT * FROM Cases WHERE created_at BETWEEN &#39;2013-05-01&#39; AND &#39;2013-05-01&#39;

But this gives no results even though there is data on the 1st.

`created_at` looks like `2013-05-01 22:25:19`, I suspect it has to do with the time? How could this be resolved?

It works just fine if I do larger date ranges, but it should (inclusive) work with a single date too.

SQL &quot;between&quot; not inclusive

I was just tidying up some sql when I came across this query:

&lt;!-- language: sql --&gt;

    SELECT 
            jm.IMEI ,
            jm.MaxSpeedKM ,
            jm.MaxAccel ,
            jm.MaxDeccel ,
            jm.JourneyMaxLeft ,
            jm.JourneyMaxRight ,
            jm.DistanceKM ,
            jm.IdleTimeSeconds ,
            jm.WebUserJourneyId ,
            jm.lifetime_odo_metres ,
            jm.[Descriptor]
    FROM    dbo.Reporting_WebUsers AS wu WITH (NOLOCK)
            INNER JOIN dbo.Reporting_JourneyMaster90 AS jm WITH (NOLOCK) ON wu.WebUsersId = jm.WebUsersId
            INNER JOIN dbo.Reporting_Journeys AS j WITH (NOLOCK) ON jm.WebUserJourneyId = j.WebUserJourneyId
    WHERE   ( wu.isActive = 1 )
            AND ( j.JourneyDuration &gt; 2 )
            AND ( j.JourneyDuration &lt; 1000 )
            AND ( j.JourneyDistance &gt; 0 )

My question is does it make any performance difference the order of the joins as for the above query I would have done 

    FROM dbo.Reporting_JourneyMaster90 AS jm

and then joined the other 2 tables to that one

Does Sql JOIN order affect performance?

I am having problem to format digits in my select column.I used FORMAT but it doesn&#39;t work.
Here is my column:

    sum(cast(datediff(second, IEC.CREATE_DATE, IEC.STATUS_DATE) as float) / 60) TotalSentMinutes    

I used this:

    FORMAT(sum(cast(datediff(second, IEC.CREATE_DATE, IEC.STATUS_DATE) as float) / 60),2) TotalSentMinutes  

ERROR: 

&gt; &#39;format&#39; is not a recognized built-in function name.

How can I format this calculation?

how to get 2 digits after decimal point in tsql?

I have a string that is up to 3 characters long when it&#39;s first created in SQL Server 2008 R2.

I would like to pad it with leading zeros, so if its original value was &#39;1&#39; then the new value would be &#39;001&#39;. Or if its original value was &#39;23&#39; the new value is &#39;023&#39;. Or if its original value is &#39;124&#39; then new value is the same as original value.

I am using SQL Server 2008 R2. How would I do this using T-SQL?

Pad a string with leading zeros so it&#39;s 3 characters long in SQL Server 2008

What is the difference between `CROSS JOIN` and `INNER JOIN`?

**CROSS JOIN:**

    SELECT 
        Movies.CustomerID, Movies.Movie, Customers.Age, 
        Customers.Gender, Customers.[Education Level], 
        Customers.[Internet Connection], Customers.[Marital Status], 
    FROM   
        Customers 
    CROSS JOIN 
        Movies

**INNER JOIN:**

    SELECT 
        Movies.CustomerID, Movies.Movie, Customers.Age, 
        Customers.Gender, Customers.[Education Level], 
        Customers.[Internet Connection], Customers.[Marital Status]
    FROM   
        Customers 
    INNER JOIN 
        Movies ON Customers.CustomerID = Movies.CustomerID

Which one is better and why would I use either one? 

CROSS JOIN vs INNER JOIN in SQL

I have a 123MB sql file which I need to execute in my local PC. But I am getting 

    Cannot execute script: Insufficient memory to continue the execution of the program

![enter image description here][1]

How to solve this issue?


  [1]: http://i.stack.imgur.com/hV4C6.png

Content Type	Original Author	Original Content on Stackoverflow
Question	Anthony	View Question on Stackoverflow
Solution 1 - Sql Server	marc_s	View Answer on Stackoverflow
Solution 2 - Sql Server	Guffa	View Answer on Stackoverflow

Is there a ternary conditional operator in T-SQL?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

matplotlib: colorbars and its text labels

Favicon not showing up in Google Chrome

Attributions