Note: This article is intended for beginners, who want to gain more knowledge and understanding on SQL Server Date Function.. Here I am explaining about some of the commonly used Date Functions. in my previous one article i have already explained about DATENAME() function which i am not going to explain again. You can find […]
Read more →Category: General
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 , […]
Read more →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… […]
Read more →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 […]
Read more →Visual Studio Gallery
Products and Extensions for Visual Studio I think some of us might have heard about Visual Studio Gallery, where microsoft show cases their own AddIns/Plugins for Microsoft Visual Studio. This includes all 3rd party extensions and addin’s too. I was searching for plugins or extension for using Team Foundation Server 2010 with Visual Studio […]
Read more →Green Revolution…
Bikes not bombs Buy Local Clean and Green Don’t be mean Go green Earth allows you to stand. Let it stand the way it is. Earth Day Every Day Eat, Sleep, Recycle Embrace the green revolution Go Green Go Green for Life Green is my favorite color Gotta dream green Green revolution the best solution […]
Read more →