Use this tag for questions specific to the 2008 R2 version of Microsoft's 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-2012In my table LoginDate 2013-08-29 13:55:48 The loginDate column's datatype is nvarchar(150) I want to convert the logindate column into …
sql datetime sql-server-2008-r2 nvarcharI 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-2012I have a very large SQL Server 2008 R2 database (1.5TB) and will be copying some data from column to column …
sql sql-server indexing sql-server-2008-r2I have a backup from database in SQL Server 2008 R2. When I want to restore this backup to SQL Server, …
sql-server-2008-r2 database-restoreWhat is the fastest way to export files (blobs) stored in a SQL Server table into a file on the …
sql sql-server-2008-r2 blobCountless times during the day I am copying and pasting records from SQL Server Management Studio to Excel. My problem …
excel sql-server-2008-r2I have SQL Server 2008 R2 inside Windows Server 2008. But when I tried to start the "SQL Server Browser" service, I …
sql-server-2008-r2How to convert datetime value to yyyymmddhhmmss? for example From 2014-04-17 13:55:12 To 20140417135512
sql-server-2008-r2 datetime-formatHere is my code: USE [xxx] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[…
sql stored-procedures sql-server-2008-r2