**The mapping is** (along with links to build lists):

  Major Version /&lt;br&gt;Compatibility Level | Version Label | File Version
   :---:|:---:|:--:
   80 | SQL Server 2000    |  8.00.xxxx
   90 | SQL Server 2005    | 9.00.xxxx
   100 | SQL Server 2008   | 10.00.xxxx
   105 | SQL Server 2008 R2 | 10.50.xxxx
   110 | [SQL Server 2012](https://sqlperformance.com/latest-builds/sql-server-2012)    | 11.00.xxxx
   120 | [SQL Server 2014](https://sqlperformance.com/latest-builds/sql-server-2014)    | 12.00.xxxx
   130 | [SQL Server 2016](https://sqlperformance.com/latest-builds/sql-server-2016)    | 13.00.xxxx
   140 | [SQL Server 2017](https://sqlperformance.com/latest-builds/sql-server-2017)    | 14.00.xxxx
   150 | [SQL Server 2019](https://sqlperformance.com/latest-builds/sql-server-2019)    | 15.00.xxxx
   160 | [SQL Server 2022](https://sqlperformance.com/latest-builds/sql-server-2022)    | 16.00.xxxx

However, just because you have a folder with one of these identifiers, does not mean you have a SQL Server instance of that version installed; some folders are laid down by newer versions for backward compatibility reasons, added by Visual Studio and other tools, or are left behind after an instance has been removed or upgraded.

**To see what you actually have installed:**

- Go to your start menu, and go to the highest version of &quot;Microsoft SQL Server 20xx&quot; that you have.
- Under that menu, go to Configuration Tools &gt; SQL Server Configuration Manager.
- In the SQL Server Services tab, sort the data by Service Type, and for each line item with the type &quot;SQL Server&quot; (not blank, or &quot;SQL Agent&quot;, or any other), right-click the SQL Server portion and select Properties.
- On the Advanced tab, scroll down, there will be a field called &quot;Version&quot;, and the number there will map to one of the patterns in the 3rd column above.

[![enter image description here][2]][2]

  [1]: http://i.stack.imgur.com/0LYy5.png
  [2]: https://i.stack.imgur.com/pI5ZZ.png

I know that Python provides an API so you can call Python interpreter in C code, but what I want is the opposite.

My program needs to use some C API, so the code must be written in C. But I also want to package the program with Python. Which means I want to invoke those C function or executables in Python. Is that possible?

If I want the C code to be a library, which means I use it with `#include` and linkage of the `*.o` likely in Python, how to do it? Is that possible? If I write the C code into executable, which means it becomes a command, can I invoke it in Python directly?

Also, I heard that Python code can be compiled, does that mean we can execute the code without the source file? Are the output files binary files? Does it improve performance?

Can we use C code in Python?

I am trying to edit some of the syntax colours in Sublime Text 3. I&#39;m using the Solarized (Light) built in colour scheme but I only want to change a few of the colours. Where is the  settings file (on a Mac)?

How do I edit the Solarized (Light) theme in Sublime Text 3

I am lucky to be an admin of a server, but I have no idea how many versions of sql server on this server. When I opened the file Microsoft SQL Server, there are files called 80, 90, 100, 110. And I have only found SQL Server 2012 setup, so what&#39;s the relationship between the files names like 80, 90, 100, 110 with sql server versions like 2008, 2012?

SQL Server file names vs versions

<p>I am lucky to be an admin of a server, but I have no idea how many versions of sql server on this server. When I opened the file Microsoft SQL Server, there are files called 80, 90, 100, 110. And I have only found SQL Server 2012 setup, so what's the relationship between the files names like 80, 90, 100, 110 with sql server versions like 2008, 2012?</p>


I&#39;m following [Code First to an Existing Database](http://msdn.microsoft.com/en-us/data/jj200620) tutorial and noticed that it suggested to connect to `(localdb)\v11.0` in learning purposes. I&#39;ve tried to connect to it using my SQL Management Studio and it worked. But when I&#39;ve restored a DB backup it created an `[DatabaseName].mdf` file in my user&#39;s directory.

I&#39;m quite surprised and have following questions:

 1. What is a `(localdb)\v11.0`? Does it uses my SQL Express or SQL Compact?
 2. Does it support only databases stored in `.mdf` files?
 3. How can I specify path for my restore other than my user&#39;s folder?
 4. What general purposes does it serve (is it for learning purposes only)?
 5. Where can I find more info about this kind of database?

 

SQL Server (localdb)\v11.0 explained

What are the practical differences between COALESCE(&lt;columnName&gt;) and ISNULL(&lt;columnName&gt;,&#39;&#39;)? 

When avoiding NULL values in SQL concatenations, which one is the best to be used?

Thanks!

SQL - Difference between COALESCE and ISNULL?

I want to connect Java class file with SQL server 2012. I have logged in with SQL server authentication, but I am receiving an error when connecting.
 
Error:

&gt; The TCP/IP connection to the host 127.0.0.1, port 1433 has failed.
&gt; Error: &quot;Connection refused: connect. Verify the connection properties.
&gt; Make sure that an instance of SQL Server is running on the host and
&gt; accepting TCP/IP connections at the port. Make sure that TCP
&gt; connections to the port are not blocked by a firewall.&quot;.

My code:

    Class.forName(&quot;com.microsoft.sqlserver.jdbc.SQLServerDriver&quot;);	//1. Register your driver
    //2. get the connection object
    //Connection con = DriverManager.getConnection(&quot;jdbc:sqlserver://localhost;databaseName=aysha&quot;,&quot;sa&quot;,&quot;admin&quot;);
    Connection con = DriverManager.getConnection(&quot;jdbc:sqlserver://127.0.0.1;databaseName=aysha&quot;,&quot;user=sa&quot;,&quot;password=admin&quot;);
     //&quot;jdbc:sqlserver://127.0.0.1:1433; Instance=SQL2008;&quot; +       &quot;databaseName=MB;user=sa;password=123;&quot;;
    //Connection con = DriverManager.getConnection(&quot;jdbc:sqlserver://localhost:1433;databaseName=aysha&quot;,&quot;sa&quot; , &quot;password&quot;);
    //3. Prepare a statement
    Statement stmt = con.createStatement();
    //4. Write the query`
    String sql = &quot;Select * from employee&quot;;
    //5. Execute the statement and 
    ResultSet rs = stmt.executeQuery(sql);
    //6. Process the result set
    
    while (rs.next())
    {
        System.out.println(rs.getInt(1));
    }



JDBC connection failed, error: TCP/IP connection to host failed

I am going to get the list of all users, including Windows users and &#39;sa&#39;, who have access to a particular database in MS SQL Server.
Basically, I would like the list to look like as what is shown in `SQL Server Management Studio` (i.e. the list that is shown when you expand `[databse] -&gt; Security -&gt; Users`) with one important exception: I do not want to see the `&#39;dbo&#39;` in the list. Rather, I would like to see the actual user who owns the database. So, for example, if &#39;sa&#39; is the `&#39;dbo&#39;`, `&#39;sa&#39;` must be included in the list instead of `&#39;dbo&#39;`. Another note not to be missed is, the list in the `SQL Server Management Studio` normally shows Windows users in addition to SQL users, And I would like those users to be included as well.

So far, I have been able to come up with the following query:

    SELECT * FROM sys.database_principals where (type=&#39;S&#39; or type = &#39;U&#39;)

This query is almost right but the problem is it doesn&#39;t satisfy the `&#39;dbo&#39;` condition. 

How can I change this query or should I use another one?

How to get the list of all database users

I have the following code which will create a comma delimited list for my results:

    DECLARE @listStr VARCHAR(MAX)
    SELECT @listStr = COALESCE(@listStr+&#39;, &#39; ,&#39;&#39;) + INSTITUTIONNAME
    FROM EDUCATION
    WHERE STUDENTNUMBER= &#39;111&#39;
    SELECT @listStr

The problem is its creating one massive comma delimited line. I need it to return a comma separated list per row.

So if `Simon` has been part of 2 institutions, then i expect:

    &quot;INSTITUTION1, INSTITUTION2&quot;

As i didnt supply a where clause i expect my results to show up like this for each row in the database.

Comma separated results in SQL

I&#39;m thinking to install *hylafax+* version 5.5.4 which was release last month on my [Debian][1] PC.

I checked `dpkg -l | grep &quot;hylafax&quot;` and found out that the current version is 5.5.3. Then I checked `apt-cache search hylafax` and saw the packages are available, but I can&#39;t see any version number.

How can I find the version of packages available in the `apt-get`?

  [1]: http://en.wikipedia.org/wiki/Debian

How to check the version before installing a package using apt-get?

I have updated Flurry via CocoaPods, but how can I check if Flurry was updated?

I mean the terminal shown me that everything is ok:

    Installing FlurrySDK (4.2.3)
    Generating Pods project
    Integrating client project

but I am not sure that it has been updated.

How to check version of a CocoaPods framework

I have big Maven (Tycho) project witch about 400 plug-ins.

We have specified version of application in each POM file.

Is there a way how to specify the version for all POM:s only on one place?

I would expect some think like:

    &lt;properties&gt;
    &lt;buildVersion&gt;1.1.2-SNAPSHOT&lt;/buildVersion&gt;
    &lt;/properties&gt;
    
    ....
    
    &lt;version&gt;${buildVersion}&lt;/version&gt;


We have parent `pom.xml`:

    &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
    &lt;groupId&gt;company&lt;/groupId&gt;
    &lt;artifactId&gt;build.parent&lt;/artifactId&gt;
    &lt;version&gt;1.1.2-SNAPSHOT&lt;/version&gt;
    &lt;packaging&gt;pom&lt;/packaging&gt;

Then in each POM is reference to parent POM:

    &lt;parent&gt;
      &lt;artifactId&gt;build.parent&lt;/artifactId&gt;
      &lt;groupId&gt;company&lt;/groupId&gt;
      &lt;relativePath&gt;../build.parent/pom.xml&lt;/relativePath&gt;
      &lt;version&gt;1.1.2-SNAPSHOT&lt;/version&gt;
    &lt;/parent&gt;

    &lt;modelVersion&gt;4.0.0&lt;/modelVersion&gt;
    &lt;groupId&gt;company&lt;/groupId&gt;
    &lt;artifactId&gt;artifact&lt;/artifactId&gt;
    &lt;version&gt;1.1.2-SNAPSHOT&lt;/version&gt;
    &lt;packaging&gt;eclipse-plugin&lt;/packaging&gt;



Maven version with a property

I want to find out which version of C# I&#39;m using.
If I would be using python I would do something like `python -V` from the command line, or type:

    import sys
    print sys.version

In PHP I would do something like this: `phpinfo();` in java: `java -version`

But I was not able to find how to achieve this in C#.

[This question][1] does not answer it, although the name suggests that it should.

I got that it depends on the .NET framework, but is there a programmatic way of figuring out my framework? I mean without going to the directory and checking the name of my .NET folders.


  [1]: https://stackoverflow.com/q/1331715/1090562

Which version of C# am I using

What are the possible ways to determine the deployed SQL Server version?

I’ve tried to do it using the SQL Server software. I want to do it using a command line SQL statement.

Content Type	Original Author	Original Content on Stackoverflow
Question	Cherry Wu	View Question on Stackoverflow
Solution 1 - Sql Server	Aaron Bertrand	View Answer on Stackoverflow

SQL Server file names vs versions

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

How do I edit the Solarized (Light) theme in Sublime Text 3

Can we use C code in Python?

Attributions

Major Version / Compatibility Level	Version Label	File Version
80	SQL Server 2000	8.00.xxxx
90	SQL Server 2005	9.00.xxxx
100	SQL Server 2008	10.00.xxxx
105	SQL Server 2008 R2	10.50.xxxx
110	SQL Server 2012	11.00.xxxx
120	SQL Server 2014	12.00.xxxx
130	SQL Server 2016	13.00.xxxx
140	SQL Server 2017	14.00.xxxx
150	SQL Server 2019	15.00.xxxx
160	SQL Server 2022	16.00.xxxx