New features of VS2012 revealed…

With the release of Visual Studio 2010 just around the corner, I was lucky enough to get a sneak peak at Visual Studio 2012. Here are a few of the exciting things I found.
http://www.ianquigley.com/A75_New_features_of_VS2012_revealed.html

div with scrollbar

when need add more data in limited space with div and if data will be bigger than space then div will be expand with scrolls.

.div id=”div1″ style=”overflow:auto;width:200px;background-color:white;max-height:200px;border-style:solid;border-width:1px;”> >

Order by clause

In order by clause in sql server,  we can use asc and desc keywords  for the accending and de-accending order. These keyword return the results by the a-z or 1-9 but , if we need to sorting,  like the order should be starts from the perticular stage then?

e.g   need results starts from b letters. then we can use order by clause like this.

select column_name from tbl oder by column_name %b