Use this tag for questions specific to the 2014 version of Microsoft's SQL Server database engine.
I have a problem with this trigger. I would like it to update the requested information only to the row …
sql sql-server tsql sql-server-express sql-server-2014I'm trying to write the following in order to get a running total of distinct NumUsers, like so: NumUsers = COUNT(…
sql sql-server tsql sql-server-2008-r2 sql-server-2014Forgive me if this question was already asked before. I just installed Microsoft SQL Server Management Studio 2014. I want to …
sql-server database sql-server-2014I know that you can't (at least not easily) restore a SQL Server 2012 backup on SQL Server 2008. But how does …
sql sql-server sql-server-2012 compatibility sql-server-2014I recently upgraded our SQL Server from 2005 to 2014 (linked server) and I am noticing that one of the stored procedures …
sql sql-server stored-procedures sql-server-2014 linked-serverWere there any changes in this area with SQL Server 2014? I’ve seen this post Is it possible to restore …
sql-server sql-server-2008 sql-server-2005 sql-server-2008-r2 sql-server-2014I am using SQL Server 2014 and want to know how to check my active transactions?
sql sql-server-2014I'm using SQL Server 2014 and having a problem. In Task Manager, on Services tab, I found SQLAgent$VILLBE_SQLSERVER (VILLBE …
sql-server-2014I'm trying to convert my Date which is (eg. 2012-04-20 05:54:59) format in into mm-yyyy. I came across some solutions …
sql sql-server tsql sql-server-2014I am using Visual Studio 2017 and SQL Server 2014. While attaching a database file to Visual Studio, I get this error: "" …
c# sql-server visual-studio-2017 sql-server-2014 sql-server-2016