Use this tag for questions specific to the 2012 version of Microsoft's SQL Server.
This is my code: USE [tempdb]; GO IF OBJECT_ID(N'dbo.t') IS NOT NULL BEGIN DROP TABLE dbo.t …
sql sql-server tsql sql-server-2012 window-functionsCannot start LocalDB instance, I have installed and re-installed over and over. Keep getting this error : Start of LocalDB instance "…
sql sql-server sql-server-2012Is there a way to persist a variable across a go? Declare @bob as varchar(50); Set @bob = 'SweetDB'; GO USE @…
sql sql-server sql-server-2008 sql-server-2012 sql-server-2000When I set this up I overlooked the retention period. My database has become pretty large so I want to …
ssis sql-server-2012I have created the user sagar in SQL Server 2012 database and mapped it to the XYZ database. After some time …
sql-server sql-server-2012I am getting this Error While I try to do BCP SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Server Native Client 11.0]…
sql-server-2012 bcpCan someone please guide me on how to overcome the following error. I am trying to install SQL Server 2012 Express …
sql-server-2012 sql-server-2012-expressThere's been a string of random occurrences of the following error in the SQL Server Agent scheduled jobs lately that …
sql-server ssis sql-server-2012 sql-server-agentWhat is the total character limit for a 900 byte index limit that SQL Server 2012 has. I created a column that …
sql-server indexing sql-server-2012I have a database A. I have taken a backup of database A called A.bak. I created a new …
sql sql-server sql-server-2012