Answer Posted / anamika devara

Getting the number of days in a year is fairly easy because you are just choosing between 365 and 366, with the latter only happening every 4 years or every leap year.  To determine if it is a leap year, either of the following conditions must be met:




The year must be divisible by 4 and must NOT be divisible by 100.
The year must be divisible by 400.
Below is a user-defined function which accepts a date as a parameter and returns the number of days in that year.





CREATE FUNCTION [dbo].[ufn_GetDaysInYear] ( @pDate    DATETIME )
RETURNS INT
AS
BEGIN




    DECLARE @IsLeapYear        BIT




    SET @IsLeapYear = 0
    IF (YEAR( @pDate ) % 4 = 0 AND YEAR( @pDate ) % 100 != 0) OR
        YEAR( @pDate ) % 400 = 0
        SET @IsLeapYear = 1




    RETURN 365 + @IsLeapYear




END
GO

What the difference between UNION and UNIONALL?

984

---

What command is used to rename the database?

945

---

Do you know hot add cpu in sql server 2008?

898

---

Can we use trigger new in before insert?

864

---

What are the differences between ms sql server & oracle?

992

---

What is difference between unique and primary key?

853

---

Write query to return all rows sql?

1003

---

What are the types of lock supported by ?

995

---

How to create a trigger for insert only?

979

---

Can a trigger be created on a view?

894

---

What are diverse clauses that form a part of sql?

1015

---

System variable and temporary variables

2182

---

Are resultset updatable?

895

---

How optimize sql query with multiple joins in sql server?

825

---

How to run sql server 2005 books online on your local system?

917

---