Another Google service which lives up to it’s name of simplicity, infact the goog.gl page is so simple, you cant use it at all! The new Goo.gl service is — for now at least — restricted only to those who use it with the Google toolbar and for those who use FeedBurner. Google claims that […]
Read more →Getting Last Day of the Month in SQL Server from current date
Note: This article intended for beginners, who are stepping in to learning SQL Server queries. Others might not feel much fancy on this queries. I created an SQL function for finding the last date of a month using the current date. Query for creating the function is as follows. SOURCE CODE //if exists drop the […]
Read more →SQL Server Date functions DateAdd() DateDiff(), DatePart(), GetDate()
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 →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 →