Top "Sql-server-2012" questions

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

How to restore a SQL Server 2012 database to SQL Server 2008 R2?

I am trying to restore the backup taken from a SQL Server 2012 to SQL Server 2008 R2, and it giving an …

sql sql-server database sql-server-2008-r2 sql-server-2012
SQL Server IIF vs CASE

I recently came to know about the availability of IIF function in SQL Server 2012. I always use nested CASE in …

sql-server sql-server-2012 case iif
Insert Multiple Rows Into Temp Table With SQL Server 2012

These StackOverflow questions here, here, and here all say the same thing, but I can't get it to run in …

sql sql-server-2012 bulkinsert
New Line Issue when copying data from SQL Server 2012 to Excel

I recently upgraded to SQL2012 and am using Management Studio. One of my columns in the database has a CHAR(13) + …

sql sql-server-2008 excel copy-paste sql-server-2012
Correct way to select from two tables in SQL Server with no common field to join on

Back in the old days, I used to write select statements like this: SELECT table1.columnA, table2.columnA FROM table1, …

sql sql-server sql-server-2012
Cannot execute script: Insufficient memory to continue the execution of the program

I have a 123MB sql file which I need to execute in my local PC. But I am getting Cannot …

sql tsql sql-server-2012
SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry

I have a strange scenario in which the auto identity int column in my SQL Server 2012 database is not incrementing …

sql sql-server sql-server-2012 identity
How do I import a .bak file into Microsoft SQL Server 2012?

Been Googling this for awhile and no answer....can anyone help?

sql sql-server sql-server-2012
SQL Server 2012 Install or add Full-text search

I am working in SQL Server 2012, and would like to use the CONTAINS() function only it seems I need to …

sql-server sql-server-2012 full-text-search
SQL Server Pre-Login Handshake Acknowledgement Error

We have a production website with a mixture of classic ASP, inline .Net and compiled .Net that talks to a …

asp.net sql-server asp-classic sql-server-2012 iis-8