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 →Search Results for: name
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 →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 →AMD Phenom II X4 965 C3 @ 7040 MHz
AMD’s Fastest Quad Core Processor – AMD Phenom-II X4 965 – C3 step running at 7040Mhz (stock 3400Mhz) overclocked. C3 step is new version slimmed down the thermal power wattage to 125W from it’s predecessor C2 with 140W, and has more over clocking capability. The cooling is achieved thrugh liquid Nitrogen.. Don’t try this in […]
Read more →ScottGu – ASP.NET 4 SEO Improvements (VS 2010 and .NET 4.0 Series)
ScottGu has published a new blog in Search Engine Optimization(SEO) improvements in VS 2010 and .NET 4.0 series. I have read it, it’s pretty straight forward, i hope you should also read the blog @ I thought of taking you to one more information article, read below. Why SEO should be important to you SEO […]
Read more →Select IN query using LINQ
In our SQL Query there is a situation when we want to fetch records based on records within the a Set of RecordID(primary key) Lets look in to one example I have a table Employee which has the columns EmpId, EmpName, EmpDesg etc. You want to select the Employee Records from Employee table with EmpID within 61,62,63 […]
Read more →