Top "Sql-server-2012" questions

Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET …

sql sql-server database sql-server-2012
Cannot Resolve Collation Conflict

I have moved one of our databases (DB1) from SQL Server 2008 to 2012 and when I run the stored procedures I …

sql sql-server sql-server-2008 sql-server-2012 collation
Insert/Update/Delete with function in SQL Server

Can we perform Insert/Update/Delete statement with SQL Server Functions. I have tried with but SQL Server error is …

sql-server sql-server-2008 sql-server-2012
System.Data.SqlClient.SqlException: Login failed for user

Working with my project in debug I have no issues. However running it in IIS I am getting this error: …

c# iis sql-server-2012 connection-string
Find Locked Table in SQL Server

How can we find which table is locked in the database? Please, suggest.

sql-server sql-server-2008 sql-server-2005 sql-server-2012 sql-server-2008-r2
Count the Number of Tables in a SQL Server Database

I have a SQL Server 2012 database called MyDatabase. How can I find how many tables are in the database? I'm …

sql-server tsql count sql-server-2012 database-table
SSIS Excel Connection Manager failed to Connect to the Source

I have a server that is capable of creating and running an Excel Import task using the Import Wizard. I …

sql-server visual-studio-2010 visual-studio ssis sql-server-2012
Possible to restore a backup of SQL Server 2014 on SQL Server 2012?

I 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-2014
Installing SQL Server 2012 - Error: Prior Visual Studio 2010 instances requiring update

I'm trying to install SQL Server 2012 Developer Edition and I can get to the point where it's doing the Installation …

visual-studio-2010 sql-server-2012
Get last 30 day records from today date in SQL Server

I have small question about SQL Server: how to get last 30 days information from this table Sample data: Product: Pdate …

sql-server sql-server-2008 sql-server-2008-r2 sql-server-2012