Tuesday, January 27, 2009

Monday, January 26, 2009

Top and Order By Combination - SQL Server knowledge center

"View object is a table expression (in sql server 2005 and above); and if you specify ORDER BY clause, the result would not be a table expression but ANSI SQL cursor statement. SQL Server 2005 and later version put View objects as pure table expression so that they will ignore TOP…ORDER BY combination in View."

Top and Order By Combination - SQL Server knowledge center

Sunday, January 18, 2009

Microsoft Virtual Labs - MSDN Virtual Lab: Application Validation through Unit Testing

Overview:
After completing this lab you'll be better able to:

  • Generate unit tests from existing code
  • Author unit tests based off pre-existing assemblies
  • Use data to drive the unit tests
  • View the test results
  • Enable code coverage and examine how well the unit tests are exercising the assembly under test

 

Microsoft Virtual Labs - System Check

Microsoft Virtual Labs - MSDN Virtual Lab: Building an Application with ASP.NET MVC

Overview:
After completing this lab you'll be better able to:

  • Create a controller
  • Display data from a model
  • Generate links
  • Handle HTML forms

Microsoft Virtual Labs - System Check