Top "Sql-server-2012" questions

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

SQL Server 2012 can't start because of a login failure

I recently installed Microsoft SQL Server 2012 on a fresh Windows 7 installation, but whenever I want to run the server, I …

sql-server permissions installation sql-server-2012
Export from SQL Server 2012 to .CSV through Management Studio

I have a SQL Server 2012 database that I am trying to export to .CSV. My knowledge of SQL is very …

sql sql-server csv sql-server-2012
Get previous and next row from rows selected with (WHERE) conditions

For example I have this statement: my name is Joseph and my father's name is Brian This statement is splitted …

sql sql-server sql-server-2012 rows
SQL Server blocked access to procedure 'sys.sp_OACreate' of component 'Ole Automation Procedures'

SQL Server blocked access to procedure sys.sp_OACreate of component 'Ole Automation Procedures' because this component is turned off …

c# sql sql-server sql-server-2012
Error restoring database backup

I am getting an error using SQL Server 2012 when restoring a backup made with a previous version (SQL Server 2008). I …

sql-server database exception-handling restore sql-server-2012
SQL - Subquery in Aggregate Function

I'm using the northwind database to refresh my SQL skills by creating some more or less complex queries. Unfortunately I …

sql subquery sql-server-2012 aggregate-functions northwind
What is the difference between a primary key and a surrogate key?

I googled a lot, but I did not find the exact straight forward answer with an example. Any example for …

sql sql-server sql-server-2008 sql-server-2005 sql-server-2012
Identity increment is jumping in SQL Server database

In one of my tables Fee in column "ReceiptNo" in SQL Server 2012 database identity increment suddenly started jumping to 100s …

sql sql-server sql-server-2012 identity-column
How do I add a “last modified” and "created" column in a SQL Server table?

I'm design a new db schema for a SQL Server 2012 database. Each table should get two extra columns called modified …

sql-server tsql triggers sql-server-2012
Get current value from a SQL Server SEQUENCE

I want to get the current value from my sequence - the same value that is shown in the sequence …

tsql sequence sql-server-2012