Top "Sql-server-2012" questions

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

Dynamically assign filename to excel connection string

This is my very first time playing with SSIS in SQL Server 2012. I can successfully read an excel file and …

sql-server ssis sql-server-2012 etl
Convert Datetime to Unix timestamp

In Microsoft SQL Server 2012 or above, is it possible to convert a datetime value to Unix time stamp in a …

sql sql-server datetime sql-server-2012 unix-timestamp
What is (are) difference between NOLOCK and UNCOMMITTED

I use SQL Server 2012. I write two queries but what is a different between NOLOCK and UnCommitted ? SELECT lastname, firstname …

sql sql-server sql-server-2012 locking isolation-level
SQL Update - Multiple Columns

I would like to update multiple columns in a table based on values from a second table using a Select …

sql tsql sql-server-2012
How to fix Visual Studio's error "This server version is not supported..." for SQL Server 2012

I recently installed Visual Studio 2010 and SQL Server 2012 on a Windows Server 2008 R2 machine - (including all updates/Service Packs). …

sql-server visual-studio visual-studio-2010 sql-server-2012 sql-server-2012-express
Scope of temporary tables in SQL Server

I wrote a stored procedure to import and transform data from one database to another. Each import would take a …

sql sql-server tsql sql-server-2012
SQL Server 2012 installation Reporting Services Catalog error

I'm installing SQL Server 2012 at the moment and when I was about to run the installation, this error pops up: …

sql sql-server visual-studio-2012 sql-server-2012
SQL Server: datediff function resulted in an overflow when using MILLISECOND

I have the following query : select CONVERT(varchar(12), DATEADD(MILLISECOND, DateDiff(MILLISECOND, '2014-08-04 10:37:28.713','2014-11-04 08:21:17.723'), 0), 114) …

sql-server sql-server-2012 date-difference
SQL Server 2012 copy database without data

We have a SQL Server 2012 database with test data in it that we used to develop a website. We will …

sql-server-2012
sql server restoring back up error

I have backed up a database I had created on an other machine running SQL server 2012 express edition and I …

backup sql-server-2012 database-backups sql-server-2012-express