`IIF` is the same as `CASE WHEN &lt;Condition&gt; THEN &lt;true part&gt; ELSE &lt;false part&gt; END`. The query plan will be the same. It is, perhaps, &quot;syntactical sugar&quot; as initially implemented.

CASE is portable across all SQL platforms whereas IIF is SQL SERVER 2012+ specific.

IIF is a non-standard T-SQL function. It was added to SQL SERVER 2012, so that Access could migrate to SQL Server without refactoring the IIF&#39;s to CASE before hand. Once the Access db is fully migrated into SQL Server, you can refactor.

Visual Studio IntelliSense for VC++ includes the &quot;complete&quot; [EDG C++ parser][1] (also used by Intel and others). Since the C# Code DOM is accessible to addons (correct me if I&#39;m wrong), is the C++ Code DOM also accessible? Can this be used to analyse an open VC++ project within the VS environment?


  [1]: http://www.edg.com/?location=c_frontend

Is the VC++ code DOM accessible from VS addons?

I have investigated a while and probably saw most popular answers here related to **aar** and **transitive dependencies** but somehow it is still not clear for me how to make this working.

So:

I have android library with given gradle config:

    apply plugin: &#39;android-library&#39;
    apply plugin: &#39;android-maven&#39;
    
    version = &quot;1.0.0&quot;
    group = &quot;com.somepackage&quot;
    
    buildscript {
        repositories {
            mavenCentral()
            mavenLocal()
        }
    
        dependencies {
            classpath &#39;com.github.dcendents:android-maven-plugin:1.0&#39;
        }
    }
    
    android {
        compileSdkVersion 19
        buildToolsVersion &#39;19.0.3&#39;
    
        defaultConfig {
            minSdkVersion 10
        }
    }
    
    repositories {
        maven { url &#39;http://www.bugsense.com/gradle/&#39; }
    }
    
    dependencies {
        provided &#39;com.google.android.gms:play-services:+&#39;
        provided &#39;com.android.support:appcompat-v7:+&#39;
        compile &#39;com.google.code.gson:gson:2.2.4&#39;
        compile &#39;com.bugsense.trace:bugsense:3.6&#39;
        compile &#39;commons-net:commons-net:3.3&#39;
    }

Then I am deploying it to local maven repo with `gradle install`. POM file of the deployed library looks like this:
                                                                                              
    &lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;
    &lt;project xsi:schemaLocation=&quot;http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd&quot; xmlns=&quot;http://maven.apache.org/POM/4.0.0&quot;
        xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot;&gt;
      &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
      &lt;groupId&gt;com.sprezzat&lt;/groupId&gt;
      &lt;artifactId&gt;app&lt;/artifactId&gt;
      &lt;version&gt;1.0.0&lt;/version&gt;
      &lt;packaging&gt;aar&lt;/packaging&gt;
      &lt;dependencies&gt;
        &lt;dependency&gt;
          &lt;groupId&gt;com.bugsense.trace&lt;/groupId&gt;
          &lt;artifactId&gt;bugsense&lt;/artifactId&gt;
          &lt;version&gt;3.6&lt;/version&gt;
          &lt;scope&gt;compile&lt;/scope&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
          &lt;groupId&gt;commons-net&lt;/groupId&gt;
          &lt;artifactId&gt;commons-net&lt;/artifactId&gt;
          &lt;version&gt;3.3&lt;/version&gt;
          &lt;scope&gt;compile&lt;/scope&gt;
        &lt;/dependency&gt;
        &lt;dependency&gt;
          &lt;groupId&gt;com.google.code.gson&lt;/groupId&gt;
          &lt;artifactId&gt;gson&lt;/artifactId&gt;
          &lt;version&gt;2.2.4&lt;/version&gt;
          &lt;scope&gt;compile&lt;/scope&gt;
        &lt;/dependency&gt;
      &lt;/dependencies&gt;
    &lt;/project&gt;

And finally gradle config of my android application using above library as a dependency:

    buildscript {
        repositories {
            mavenCentral()
        }
        dependencies {
            classpath &#39;com.android.tools.build:gradle:0.9.+&#39;
        }
    }
    apply plugin: &#39;android&#39;
    
    repositories {
        mavenCentral()
        mavenLocal()
    }
    
    android {
        compileSdkVersion 15
        buildToolsVersion &quot;19.0.2&quot;
    
        defaultConfig {
            minSdkVersion 10
            targetSdkVersion 18
        }
    }
    
    dependencies {
        compile &#39;com.google.android.gms:play-services:+&#39;
        compile &#39;com.android.support:appcompat-v7:+&#39;
        compile &#39;com.somepackage:LIBRARY_NAME:1.0.0@aar&#39;
    }

And after deploying application on phone I am getting `NoClassDefFoundError` for classes belonging to compile dependencies of my android library. 

Inspecting my android application dependencies using `gradle dependencies`:

    apk - Classpath packaged with the compiled main classes.
    +--- com.google.android.gms:play-services:+ -&gt; 4.3.23
    |    \--- com.android.support:support-v4:19.0.1 -&gt; 19.1.0
    +--- com.android.support:appcompat-v7:+ -&gt; 19.1.0
    |    \--- com.android.support:support-v4:19.1.0
    \--- com.somepackage:LIBRARY_NAME:1.0.0

According to above tree, all transitive dependencies are not detected. Where is the problem and how should it be done correctly?

Transitive dependencies not resolved for aar library using gradle

I recently came to know about the availability of `IIF` function in SQL Server 2012. I always use nested `CASE` in my queries. I want to know the exact purpose of the `IIF` statement and when should we prefer using `IIF` over `CASE` Statement in the query.
I mostly use nested `CASE` in my queries.

Thanks for all the inputs.

SQL Server IIF vs CASE

<p>I recently came to know about the availability of <code>IIF</code> function in SQL Server 2012. I always use nested <code>CASE</code> in my queries. I want to know the exact purpose of the <code>IIF</code> statement and when should we prefer using <code>IIF</code> over <code>CASE</code> Statement in the query.
I mostly use nested <code>CASE</code> in my queries.</p>
<p>Thanks for all the inputs.</p>


I&#39;m wondering if it&#39;s possible to setup SQL Server to have multiple rows of tabs for files / queries. 

I have a lot of queries I want to switch between, and could move them to different horizontal groups, but I think two rows would be much easier to navigate than that pin on the left that drops down the big list of open queries.

Visual Studio kind of supports this if you pin enough code windows to fill up the top bar. 

Is there something similar in SQL Server?

Edit:

I&#39;m trying to achieve something like this (screenshot from Visual Studio)

![Multiple Tabs][1]

While SQL Server is more like this

![Management Studio][2]

  [1]: http://i.stack.imgur.com/Lcsh4.png
  [2]: http://i.stack.imgur.com/dLZeQ.png

Can I have multiple rows of tabs in SQL Server Management Studio

I have a stored procedure that takes in two parameters. I can execute it successfully in Server Management Studio. It shows me the results which are as I expect. However it also returns a Return Value.

It has added this line,

     SELECT &#39;Return Value&#39; = @return_value

I would like the stored procedure to return the table it shows me in the results not the return value as I am calling this stored procedure from MATLAB and all it returns is true or false.

Do I need to specify in my stored procedure what it should return? If so how do I specify a table of 4 columns (varchar(10), float, float, float)?

SQL server stored procedure return a table

I am using `SQL Server 2008 R2`. It is working fine. But recently, I have changed my hosting server and I came to know that they have installed `SQL Server 2012` on Server.&lt;br&gt;&lt;br&gt;
Now, Issue is that after connecting with Server Database through `SQL Server 2008 R2`, When I click on any table name or Stored Procedure, I am getting error : `Index was outside the bounds of the array. (Microsoft.SqlServer.smo)`&lt;br&gt;&lt;br&gt;
So, is there any issue from my side or It is from Server Side ??? and How can I prevent this issue ?

Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)

How to get all the dates between two dates?

I have a variable `@MAXDATE` which is storing the maximum date from the table. Now I want to get the all dates between `@Maxdate` and `GETDATE()` and want to store these dates in a cursor.

So far I have done as follows:

    ;with GetDates As  
    (  
        select DATEADD(day,1,@maxDate) as TheDate
        UNION ALL  
        select DATEADD(day,1, TheDate) from GetDates  
        where TheDate &lt; GETDATE()  
    )  

This is working perfectly but when I am trying to store these values in a cursor

    SET @DateCurSor = CURSOR FOR
    				SELECT TheDate
    				FROM GetDates

Compilation Error

&gt; Incorrect syntax near the keyword &#39;SET&#39;.

How to solve this?

Get all dates between two dates in SQL Server

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn&#39;t.

I tried to run the installer again, and it gave me options to repair or uninstall. I had the formatter installed prior to installing 2014.

EDIT: [The tool is available here.][1]


  [1]: http://architectshack.com/PoorMansTSqlFormatter.ashx

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

I&#39;m installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up: 

![The errors can be seen clearly in this picture][1]


On clicking the first failed test, which is &quot;Reporting Services Catalog Database File Existence&quot;, this is what i get:

![enter image description here][2]


On clicking the second failed test, which is &quot;Reporting Services Catalog Temporary Database File Existence&quot;, this is what i get:

![enter image description here][3]


  [1]: http://i.stack.imgur.com/rgr1C.png
  [2]: http://i.stack.imgur.com/Ipmqu.png
  [3]: http://i.stack.imgur.com/MV3XS.png

So basically, both of the message box says me that &quot;Catalog Database File&quot; &amp; &quot;Catalog Temporary database files exists&quot;. Because of this, i need to select Reporting Services file-only mode installation. 

My questions are:

 1. How do i select file-only mode installation?
 2. Do i&#39;ve to close the setup and do something and afterwards run the setup again?
 
Btw, I had SQL Server 2012 installed before. I uninstalled it completely due to some strange errors and decided to reinstall a fresh copy of SQL Server 2012 and now I&#39;m stuck with these errors. Any help will be sincerely appreciated. :)

SQL Server 2012 installation Reporting Services Catalog error

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I am trying to automate that process by using a visual Studio 2010 Integration Services package, that I am developing on that server.

The problem happens when trying to design the package.  I have added an excel connection and pointed it at the Excel file on a local disk (the same file I have already successfully imported using the import wizard). When I add an Excel Source to the DataFlow and specify the excel connection, when I go to the Name Of the Excel Sheet Drop down I just see &quot;No tables or views can be loaded&quot; and get the following error.

&quot;Could not retrieve the table information for the connection manager.
Failed to connect to the source using the connection manager ...&quot;

I can&#39;t find this error logged anywhere and i don&#39;t know why it is failing. The directory is shared to Authenticated users and the file is not in use.

Any ideas how to debug this error? I understand there can be issues running this in 64 bit mode, but does that apply to development?

I should add that it is an excel 2007 file .XLSX and the connection is set to Excel 2007.

2019-11-08 The answer by GavB841 below looks promising, if anyone tries it and it works please let me know. (I am no longer working in this area.)

SSIS Excel Connection Manager failed to Connect to the Source

I know that you can&#39;t (at least not easily) restore a SQL Server 2012 backup on SQL Server 2008. But how does it work for SQL Server 2014 to SQL Server 2012 ?

On database level there is the property to adjust the compatibility mode to any other SQL Server version.

How does this helps or work ? Will it only disallow the features from 2014? 

To be honest I already tried to restore a backup, but 2012 didn&#39;t recognize the datafile, so I couldn&#39;t click `ok Button` to start the restore procedure.

Did I miss some important option ?

Possible to restore a backup of SQL Server 2014 on SQL Server 2012?

I use SQL Server 2012.

I write two queries but what is a different between `NOLOCK` and `UnCommitted` ? 

    SELECT lastname, firstname
    FROM HR.Employees with (READUNCOMMITTED)

    SELECT lastname, firstname 
    FROM HR.Employees with (NoLock)




What is (are) difference between NOLOCK and UNCOMMITTED

Is it possible to do the following:

    IF [a] = 1234 THEN JOIN ON TableA 
    ELSE JOIN ON TableB

If so, what is the correct syntax?

Conditional JOIN Statement SQL Server

Here is an extract of my table:

      gid    |    datepose    |    pvc
    ---------+----------------+------------
     1       |  1961          | 01
     2       |  1949          |
     3       |  1990          | 02
     1       |  1981          |
     1       |                | 03
     1       |                |

I want to fill the PVC column using a `SELECT CASE` as bellow:

    SELECT

     gid,

     CASE
      WHEN (pvc IS NULL OR pvc = &#39;&#39;) AND datpose &lt; 1980) THEN &#39;01&#39;
      WHEN (pvc IS NULL OR pvc = &#39;&#39;) AND datpose &gt;= 1980) THEN &#39;02&#39;
      WHEN (pvc IS NULL OR pvc = &#39;&#39;) AND (datpose IS NULL OR datpose = 0) THEN &#39;03&#39;
     END AS pvc

    FROM my_table ;

The result is the same content as source table, nothing has happened and I get no error message in pg_log files. It might be a syntax error, or a problem with using multiple conditions within WHEN clauses?

Thanks for help and advice! 

   

PostgreSQL CASE ... END with multiple conditions

How do I create an a statement with an inline If (IIf, see also: [Immediate if](http://en.wikipedia.org/wiki/IIf) or [ternary If](https://en.wikipedia.org/wiki/%3F)) in PowerShell?

&lt;strike&gt;If you also think that this should be a native PowerShell function, please vote this up: https://connect.microsoft.com/PowerShell/feedback/details/1497806/iif-statement-if-shorthand&lt;/strike&gt;

Update (7 October 2019)
-----------------------
The [Microsoft Connect](https://connect.microsoft.com/PowerShell/feedback/details/1497806/iif-statement-if-shorthand) is retired, but the good news is that [support for a ternary operator in PowerShell (Core) language](https://github.com/PowerShell/PowerShell/pull/10367) appears to be on its way...



Content Type	Original Author	Original Content on Stackoverflow
Question	neophyte	View Question on Stackoverflow
Solution 1 - Sql Server	Karl Kieninger	View Answer on Stackoverflow
Solution 2 - Sql Server	user2505560	View Answer on Stackoverflow

SQL Server IIF vs CASE

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Transitive dependencies not resolved for aar library using gradle

Is the VC++ code DOM accessible from VS addons?

Attributions