Notebook is light and portable to carry around but it is not as scalable or upgradable as compared to desktop PC. This is especially true when come to handle graphics intensive applications such as gaming with rich 3D multimedia capability. In view of such limitation, AMD (Advanced Micro Device) has able to achieve a new […]
Read more →Google’s new Short URL Service goo.gl
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 →