    select name, compatibility_level , version_name = 
    CASE compatibility_level
    	WHEN 65  THEN &#39;SQL Server 6.5&#39;
    	WHEN 70  THEN &#39;SQL Server 7.0&#39;
    	WHEN 80  THEN &#39;SQL Server 2000&#39;
    	WHEN 90  THEN &#39;SQL Server 2005&#39;
    	WHEN 100 THEN &#39;SQL Server 2008/R2&#39;
    	WHEN 110 THEN &#39;SQL Server 2012&#39;
    	WHEN 120 THEN &#39;SQL Server 2014&#39;
        WHEN 130 THEN &#39;SQL Server 2016&#39;
        WHEN 140 THEN &#39;SQL Server 2017&#39;
        WHEN 150 THEN &#39;SQL Server 2019&#39;
        ELSE &#39;new unknown - &#39;+CONVERT(varchar(10),compatibility_level)
    END
    from sys.databases



    select compatibility_level from sys.databases where name =&#39;myDB&#39;

Thought this would be useful here...

    65 = SQL Server 6.5
    70 = SQL Server 7.0
    80 = SQL Server 2000
    90 = SQL Server 2005
    100 = SQL Server 2008/R2
    110 = SQL Server 2012
    120 = SQL Server 2014
    130 = SQL Server 2016




How to check SQL Server Database compatibility 
&lt;pre&gt;

       SELECT compatibility_level  as [Current compatibility_level] FROM
         sys.databases WHERE name = &#39;Database Name&#39;;

&lt;/pre&gt;

I&#39;d like to add the answer from msdn:

    USE AdventureWorks2012;
    GO
    SELECT compatibility_level
    FROM sys.databases WHERE name = &#39;AdventureWorks2012&#39;;
    GO
https://msdn.microsoft.com/en-us/library/bb933794.aspx

This question is a spin-off from [this one][1]. Some history: when I first learned Perl, I pretty much always used `glob` rather than `opendir` + `readdir` because I found it easier. Then later various posts and readings suggested that `glob` was bad, and so now I pretty much always use `readdir`.

After thinking over [this recent question][2] I realized that my reasons for one or the other choice may be bunk. So, I&#39;m going to lay out some pros and cons, and I&#39;m hoping that more experienced Perl folks can chime in and clarify. The question in a nutshell is are there compelling reasons to prefer `glob` to `readdir` or `readdir` to `glob` (in some or all cases)?

### `glob` pros:

 1. No dotfiles (unless you ask for them)
 2. Order of items is guaranteed
 3. No need to prepend the directory name onto items manually
 4. Better name (c&#39;mon - `glob` versus `readdir` is no contest if we&#39;re judging by names alone)
 5. (From [ysth&#39;s answer](#1507507); cf. `glob` cons 4 below) Can return non-existent filenames:

        @deck = glob &quot;{A,K,Q,J,10,9,8,7,6,5,4,3,2}{\x{2660},\x{2665},\x{2666},\x{2663}}&quot;;


### `glob` cons:

 1. Older versions are just plain broken (but &#39;older&#39; means pre 5.6, I think, and frankly if you&#39;re using pre 5.6 Perl, you have bigger problems)
 2. Calls `stat` each time (i.e., useless use of `stat` in most cases).
 3. Problems with spaces in directory names (is this still true?)
 4. (From [brian&#39;s answer](#1506886)) Can return filenames that don&#39;t exist:

        $ perl -le &#39;print glob &quot;{ab}{cd}&quot;&#39;

### `readdir` pros:

 1. (From [brian&#39;s answer](#1506886)) `opendir` returns a filehandle which you can pass around in your program (and reuse), but `glob` simply returns a list
 2. (From [brian&#39;s answer](#1506886)) `readdir` is a proper iterator and provides functions to `rewinddir`, `seekdir`, `telldir`
 3. Faster? (Pure guess based on some of `glob`&#39;s features from above. I&#39;m not really worried about this level of optimization anyhow, but it&#39;s a theoretical pro.)
 4. Less prone to edge-case bugs than `glob`?
 5. Reads everything (dotfiles too) by default (this is also a con)
 6. May convince you not to name a file `0` (a con also - see [Brad&#39;s answer](#2365358))
 7. Anyone? Bueller? Bueller?

### `readdir` cons:

 1. If you don&#39;t remember to prepend the directory name, you **will** get bit when you try to do filetests or copy items or edit items or...
 2. If you don&#39;t remember to `grep` out the `.` and `..` items, you **will** get bit when you count items, or try to walk recursively down the file tree or...
 3. Did I mention prepending the directory name? (A sidenote, but my very first post to the Perl Beginners mail list was the classic, &quot;Why does this code involving filetests not work some of the time?&quot; problem related to this gotcha. Apparently, I&#39;m still bitter.)
 4. Items are returned in no particular order. This means you will often have to remember to sort them in some manner. (This could be a pro if it means more speed, and if it means that you actually *think* about how and if you need to sort items.) **Edit**: Horrifically small sample, but on a Mac `readdir` returns items in alphabetical order, case insensitive. On a Debian box and an OpenBSD server, the order is utterly random. I tested the Mac with Apple&#39;s built-in Perl (5.8.8) and my own compiled 5.10.1. The Debian box is 5.10.0, as is the OpenBSD machine. I wonder if this is a filesystem issue, rather than Perl? 
 5. Reads everything (dotfiles too) by default (this is also a pro)
 6. Doesn&#39;t necessarily deal well with a file named `0` (see pros also - see [Brad&#39;s answer](#2365358))

 


  [1]: https://stackoverflow.com/questions/1499672/how-do-i-open-an-array-of-files-in-perl
  [2]: https://stackoverflow.com/questions/1499672/how-do-i-open-an-array-of-files-in-perl

What reasons are there to prefer glob over readdir (or vice-versa) in Perl?

Quite simple, I&#39;m learning Python, and I can&#39;t find a reference that tells me how to write the following:

```lang-cs
public class Team {
     private String name;
     private String logo;
     private int members;

     public Team(){}

     // Getters/setters
}
```

Later:

    Team team = new Team();
    team.setName(&quot;Oscar&quot;);
    team.setLogo(&quot;http://....&quot;);
    team.setMembers(10);

That is a class Team with the properties: name/logo/members

**Edit**

After a few attempts I got this:

    class Team:
        pass

Later

    team = Team()
    team.name = &quot;Oscar&quot;
    team.logo = &quot;http://...&quot;
    team.members = 10

Is this the Python way? It feels odd (coming from a strongly typed language of course).


How can I define a class in Python?

According to BOL (SQL Server Books Online) on [`sp_dbcmptlevel`][1], &lt;br /&gt;

&gt; This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use ALTER DATABASE Compatibility Level instead.

Now, the only TSQL way I know of checking database compatibility is through `sp_dbcmptlevel`.
As far as I know, [`ALTER DATABASE Compatibility Level`][2] is just for **setting** the compatibility level, not getting info.

How should one to get compatibility level without using GUI?


  [1]: http://technet.microsoft.com/en-us/library/ms178653.aspx
  [2]: http://technet.microsoft.com/en-us/library/bb510680.aspx

How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?

According to BOL (SQL Server Books Online) on <a href="http://technet.microsoft.com/en-us/library/ms178653.aspx" target="_blank" rel="noopener noreferrer"><code>sp_dbcmptlevel</code></a>, 
> This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible. Use ALTER DATABASE Compatibility Level instead.
Now, the only TSQL way I know of checking database compatibility is through <code>sp_dbcmptlevel</code>.
As far as I know, <a href="http://technet.microsoft.com/en-us/library/bb510680.aspx" target="_blank" rel="noopener noreferrer"><code>ALTER DATABASE Compatibility Level</code></a> is just for setting the compatibility level, not getting info.
How should one to get compatibility level without using GUI?

I am looking for a good SQL Statement to select all rows from the previous day from one table. The table holds one datetime column. I am using SQL Server 2005.


SQL statement to select all rows from previous day

Can anyone tell me if there is an equivalent of `SCOPE_IDENTITY()` when using GUIDs as a primary key in SQL Server?

I don&#39;t want to create the GUID first and save as a variable as we&#39;re using sequential GUIDs as our primary keys.

Any idea on what the best way to retrieve the last inserted GUID primary key?

SCOPE_IDENTITY() for GUIDs?

How do I convert a string of format `mmddyyyy` into `datetime` in SQL Server 2008?

My target column is in `DateTime`

I have tried with `Convert` and most of the `Date` style values however I get an error message:

&gt;&#39;The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.&#39; 

Convert varchar into datetime in SQL Server

I am using SQL Server 2008 Management Studio and have a table I want to migrate to a different db server.

Is there any option to export the data as an insert into SQL script?? 

Exporting data In SQL Server as INSERT INTO

I use ADO.NET as well as the sqlcmd utility to send SQL scripts to SQL Server 2008. What is the difference between using `;` and `GO` to separate chunks of SQL?


What is the difference between &quot;;&quot; and &quot;GO&quot; in T-SQL?

I just need to select the first day of the month of a given DateTime variable.

I know it&#39;s quite easy to do using this kind of code:

    select CAST(CAST(YEAR(@mydate) AS VARCHAR(4)) 
    + &#39;/&#39; + CAST(MONTH(@mydate) AS VARCHAR(2)) + &#39;/01&#39; AS DATETIME)

But unfortunately, this is not very elegant, and not very fast either.

Is there a better way to do this? I&#39;m using SQL Server 2008.

How can I select the first day of a month in SQL?

In SQL Server 2005 I have a table `cm_production` that lists all the code that&#39;s been put into production. The table has a `ticket_number`, `program_type`, `program_name` and `push_number` along with some other columns. 

GOAL: Count all the DISTINCT program names by program type and push number.

What I have so far is:
    
    DECLARE @push_number INT;
    SET @push_number = [HERE_ADD_NUMBER];

    SELECT DISTINCT COUNT(*) AS Count, program_type AS [Type] 
    FROM cm_production 
    WHERE push_number=@push_number 
    GROUP BY program_type

This gets me partway there, but it&#39;s counting all the program names, not the distinct ones (which I don&#39;t expect it to do in that query). I guess I just can&#39;t wrap my head around how to tell it to count only the distinct program names without selecting them. Or something. 

Selecting COUNT(*) with DISTINCT

I&#39;d like to determine the primary key of a table using TSQL (stored procedure or system table is fine). Is there such a mechanism in SQL Server (2005 or 2008)?

Determine a table&#39;s primary key using TSQL

I&#39;m maintaining library written for PHP 5.2 and I&#39;d like to create PHP 5.3-namespaced version of it. However, I&#39;d also keep non-namespaced version up to date until PHP 5.3 becomes so old, that even Debian stable ships it ;)

I&#39;ve got rather clean code, about 80 classes following `Project_Directory_Filename` naming scheme (I&#39;d change them to `\Project\Directory\Filename` of course) and only few functions and constants (also prefixed with project name).

Question is: what&#39;s the best way to develop namespaced and non-namespaced versions in parallel?

* Should I just create fork in repository and keep merging changes between branches? Are there cases where backslash-sprinkled code becomes hard to merge?

* Should I write script that converts 5.2 version to 5.3 or vice-versa? Should I use PHP tokenizer? `sed`? C preprocessor?

* Is there a better way to use namespaces where available and keep backwards compatibility with older PHP?

----

*Update: [Decided against use of namespaces after all](http://pornel.net/phpns).*

Strategy for developing namespaced and non-namespaced versions of same PHP code

I&#39;m trying to create a custom TCP stack using Python 2.6.5 on Windows 7 to serve valid http page requests on port 80 locally.  But, I&#39;ve run into a snag with what seems like Windows 7 tightened up security.  This code worked on Vista.

Here&#39;s my sample code:

    import SocketServer
    import struct
    
    class MyTCPHandler(SocketServer.BaseRequestHandler):
        def handle(self):
            headerText = &quot;&quot;&quot;HTTP/1.0 200 OK
                            Date: Fri, 31 Dec 1999 23:59:59 GMT
                            Content-Type: text/html
                            Content-Length: 1354&quot;&quot;&quot;
            bodyText = &quot;&lt;html&gt;&lt;body&gt;some page&lt;/body&gt;&lt;/html&gt;&quot;
            self.request.send(headerText + &quot;\n&quot; + bodyText)
    
    if __name__ == &quot;__main__&quot;:
        HOST, PORT = &quot;localhost&quot;, 80
        server = SocketServer.TCPServer((HOST, PORT), MyTCPHandler)
        server.serve_forever()



&gt; &lt;b&gt;C:\python&gt;python TestServer.py&lt;/b&gt;
&gt; Traceback (most recent call last):  
&gt; File &quot;TestServer.py&quot;, line 19, in
&gt; &lt;module&gt;
&gt;     server = SocketServer.TCPServer((HOST, PORT),
&gt; MyTCPHandler)   File
&gt; &quot;C:\Python26\lib\SocketServer.py&quot;,
&gt; line 400, in __init__
&gt;     self.server_bind()   File &quot;C:\Python26\lib\SocketServer.py&quot;,
&gt; line 411, in server_bind
&gt;     self.socket.bind(self.server_address) 
&gt; File &quot;&lt;string&gt;&quot;, line 1, in bind
&gt; 
&gt; socket.error: [Errno 10013] An attempt
&gt; was made to access a socket in a way
&gt; forbidden by its access permissions

How exactly do I get this to work on Windows 7?

[Edit on 5/5/2010 @ 2344 PDT]  This &lt;a href=&quot;https://stackoverflow.com/questions/550032/what-causes-python-socket-error&quot;&gt;answer&lt;/a&gt; explains that the error is caused by the need for elevated / superuser privileges when accessing ports lower than 1024.  I&#39;m going to try using a higher port number to see if that works.  However, I still would like to know why my local admin account can&#39;t access port 80.  

socket.error: [Errno 10013] An attempt was made to access a socket in a way forbidden by its access permissions

With iOS 4 coming out soon, I have already planned to include an iAd in a future update of an app of mine. I assume that this will make my app unusable for anyone on a firmware lower than 4.0. Is there a way to change those variables and the .xib file based on the user&#39;s firmware?



How to make an iPhone app compatible with multiple SDK (firmware) versions

I&#39;m building a small Java app and hoping to use logback for logging.

My app has a dependency on an older project that does its logging via 

    org.apache.commons | com.springsource.org.apache.commons.logging | 1.1.1

...so my plan was to use 

    org.slf4j | jcl-over-slf4j | 1.5.6

...to redirect the JCL logging to 

    org.slf4j | slf4j-api | 1.6.0

...and ultimately to 

    ch.qos.logback | logback-classic | 0.9.22
    ch.qos.logback | logback-core | 0.9.22

so my app can log through logback via its slf4j API while the old library code can log into the same location via the redirection.

Alas, this results in 

    java.lang.NoSuchMethodError: org.slf4j.spi.LocationAwareLogger.log(Lorg/slf4j/Marker;Ljava/lang/String;ILjava/lang/String;Ljava/lang/Throwable;)V
	at   org.apache.commons.logging.impl.SLF4JLocationAwareLog.info(SLF4JLocationAwareLog.java:141)

I&#39;ve tried higher and lower verision numbers on some of these jars and also digging through API documentation and such... but I&#39;m unable to find and solve the problem. 

Help, please?

Although logback is considered the &quot;strategic&quot; logging framework, I have some leeway in which logging mechanism I ultimately use. I&#39;d hope to use either logback or log4j, though, and I definitely want to merge the old project&#39;s logging into whatever the &quot;new&quot; logging framework ends up being, via a common configuration.

Logging framework incompatibility

I do most of my programming in Python 3.x on Windows 7, but now I need to use the Python Imaging Library (PIL), ImageMagick, and wxPython, all of which require Python 2.x.

Can I have both Python 2.x and Python 3.x installed in Windows 7? When I run a script, how would I &quot;choose&quot; which version of Python should run it? Will the aforementioned programs be able to handle multiple versions of Python installed at once? I have searched for hours and hours for how to do this to no avail.

Thanks.

Content Type	Original Author	Original Content on Stackoverflow
Question	dance2die	View Question on Stackoverflow
Solution 1 - Sql Server	Nick Kavadias	View Answer on Stackoverflow
Solution 2 - Sql Server	mjv	View Answer on Stackoverflow
Solution 3 - Sql Server	sam yi	View Answer on Stackoverflow
Solution 4 - Sql Server	user6341745	View Answer on Stackoverflow
Solution 5 - Sql Server	Jacky	View Answer on Stackoverflow

How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Solution 3 - Sql Server

Solution 4 - Sql Server

Solution 5 - Sql Server

How can I define a class in Python?

What reasons are there to prefer glob over readdir (or vice-versa) in Perl?

Attributions