
there is no specific differences only in terms of SPs, but you can see the below for your understanding...
Mainly the differences between MsSQL 2008 R2 to 2012 at low-level are:
1. enhanced features for querying are introduces in MSSQL 2012.
FORMAT(), CONCAT(), TRY_CONVERT() and OLAP window functions such as LAG(), LEAD(), LAST_VALUE() and FIRST_VALUE() functions
you can look into the top features of Denali ( MSSQL 2012) online.
2. there was no casting for money column in SQL Server 2008 whereas MSSQL 2012 have the solution for cast a money field, this is done by FORMAT() function.
DECLARE @money money = '215600';
SELECT FORMAT ( @money, 'C') AS MoneyFormatinUSDollars;
Output:
$215,600.00
3. Pagination can be done in SQL Server 2012 by using two keywords (OFFSET, FETCH NEXT) with Order By Clause whereas the code is lengthy and complex in SQL SERVER 2008 R2 . For your reference,
http://stackoverflow.com/questions/2244322/how-to-do-pagination-in-sql-server-2008?rq=1 4. SSIS-wise, SQL Server 2012 is having SSDT tool whereas SQL server 2008 R2 is having BIDS( Business Intelligence Development Studio). SQL Server 2012 provides you 'Integration Catalog' for deploying packages onto server.
5. Sequence objects are introduced in MSSQL 2012. you look for this online..
6. Error Handling is also very comfortable in MSSQL 2012. They have introduced
THROW begin try
-- The code where error has occurred.
end try
begin catch
-- throw error to the client
Throw;
end catch
refer this for high-level differences
http://touchstone-systems.co.uk/blog/?p=74 Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif
Sriharim, if this helps please login to Mark As Answer. | Alert Moderator