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… Continue reading
Author: Nithin Mohan TK
Technology Enthusiast | .NET Specialist | Blogger | Gadget & Hardware Geek
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… Continue reading
Silverlight 4 Training Kit from Microsoft
Silverlight 4 Training Kit The Silverlight 4 Training Course includes hands-on-labs, a video and a whitepaper designed to help you learn about the new features in Silverlight 4 focusing on three major areas: Enabling Business Application Development, Empowering Richer Experiences and Moving Beyond the Browser. Some of the new highly anticipated features include Printing, WebCam… Continue reading
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 – Areas Support
ASP.NET MVC 2 introduces the concept of Areas. Areas provide a means of dividing a large web application into multiple projects, each of which can be developed in relative isolation. The goal of this feature is to help manage complexity when developing a large site by factoring the site into multiple projects, which get combined… Continue reading