SQL Server 2008 Books Online is updated on 31 October 2008. I always bookmark latest BOL for my easy reference. Here is what was updated in October 2008, area by area. In short, the Book Online updated in October brings new and revised topics.
Getting Started: New and Updated Topics (31 October 2008)
Analysis Services – Multidimensional Data: New and Updated Topics (31 October 2008)
Database Engine: New and Updated Topics (31 October 2008)
Integration Services: New and Updated Topics (31 October 2008)
Analysis Services – Data Mining: New and Updated Topics (31 October 2008)
Reporting Services: New and Updated Topics (31 October 2008)
What the Book Online Updated in October 2008 Covers
Each area in the list above had its own page of new and changed topics. I found these pages more useful than the refresh itself. Instead of reading the whole documentation again, you could open the list for your area, such as the Database Engine or Integration Services, and read only what changed. It saved me a lot of time with every refresh.
My simple routine when a documentation refresh came out was this:
- Open the list of new and changed topics for the areas I work with.
- Read any topic about a feature I already use in production, because a changed page often means a mistake was fixed or a warning was added.
- Try the new examples on a test server before copying them into real code.
- Replace my local copy so I stop reading old pages by accident.
Documentation for a new release is never finished on day one. SQL Server 2008 was only a few months old at this point, and new and corrected topics were still arriving. That is normal, and it is also why comments and feedback from readers matter. Every report from a reader makes the next version a little better.
Today this download is history, and the link may not open. The SQL Server documentation now lives online on Microsoft Learn, and each page shows when it was last changed. The habit still works though. When you depend on a feature, check its page again from time to time. You might find a new limitation, a better example, or a note that saves you from a bad day.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
4 Comments. Leave new
How do i round 1.0847 to 1.09 using round function in sql server 2005
wating for a reply
thanks in advance .
1.0847 will not round to 1.09 (1.0857 would round to 1.09).
Regardless the function is either:
CONVERT(DECIMAL(3,2),1.0847) = 1.08
or
ROUND(1.0847, 2) = 1.0800
You could also do this if you wanted to get 1.09 from 1.0857:
SELECT CONVERT(DECIMAL(3,2),CONVERT(DECIMAL(4,3),1.0847))
Convert twice the number to make 2 + 2 = 1 :0)
Hi,
@ archana
try this. hope this will help u.
select convert(decimal(3,2),convert(decimal(4,3),1.0847))
Regards,
Neetu