Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I would like to return the total number of records in the database so I can set up pagination. How …
sql-server paging sql-server-2008-r2I'm performing a bulk data import on CSV files. In the CSV files, my 'Date' column contains a date in …
sql sql-server sql-server-2008 sql-server-2008-r2 data-importI am running 2008 R2 I have an entire set of reports that I have to load into RS. These were …
sql-server ssrs-2008 sql-server-2008-r2 reporting-servicesI recognize there has been many questions posted about converting strings to datetime already but I haven't found anything for …
sql-server datetime sql-server-2008-r2 datetime-formatI'm aware of this topic ( Find a specific column in an unknown table in a database? ) and my problem is …
sql sql-server sql-server-2008-r2 information-schemaWhat is best practice for handling the dropping of a temp table. I have read that you should explicitly handle …
sql-server sql-server-2008-r2I have a table that looks something like: AccountID, ItemID 1, 100 1, 200 2, 300 I have a proc that accepts a table value parameter …
sql-server tsql merge sql-server-2008-r2I am trying to generate an Pivot table with SQL (SQL Server 2008). To get the column list I am using …
sql sql-server-2008-r2 sql-functionI've recently had to install SQL Server and restore a database to 2 laptops, the first took me a couple of …
database sql-server-2008 sql-server-2008-r2 sql-server-2012 connection-stringHow can you get SQLCMD, when executing a SQL script file, to just output any errors or warnings it encounters? …
sql sql-server sql-server-2008-r2 sqlcmd