DATENAME() function in SQ Server

SQL has a DateName function, however it takes a datetime as a parameter, not a number Usage is as follows DATENAME(month,date) returns Month Name Sample Query SELECT DATENAME(month, GETDATE()) AS ‘Month Name’—————————— Output: January   Suppose i want to print previous month date, how can i do. There is a quick way. print(DATENAME(month,DATEADD (month ,… Continue reading

Design Patterns – ‘Abstract Factory’

Provide an interface for creating families of related or dependent objects without specifying their concrete classes.  An AbstractFactory is a class that exists to create instances of another class. Described on page 87 of the DesignPatternsBook. Typically, if you want to construct instances of a class, where the class is selected at run time, you…… Continue reading

ASP.NET MVC 2

ASP.NET MVC 2 is the next significant update of ASP.NET MVC. It is a compatible update to ASP.NET MVC 1 – so all the knowledge, skills, code, and extensions you already have with ASP.NET MVC continue to work and apply going forward. Like the ASP.NET MVC 1.0 , Microsoft also shipping the source code for… Continue reading

Design Patterns in .NET

Introduction Design patterns are recurring solutions to software design problems you find again and again in real-world application development. Patterns are about design and interaction of objects, as well as providing a communication platform concerning elegant, reusable solutions to commonly encountered programming challenges There are so many design patterns available for Software application development, depending… Continue reading