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

How to get a list of columns in a view using the "sp_help" stored procedure?

1028

---

Can sql servers linked to other servers like oracle?

938

---

What is data modeling and Reterminal integrity?

1951

---

What is the difference between char, varchar and nvarchar?

1019

---

Is sql server a database?

981

---

What is #temp and @table variable in SQL server?

1078

---

Explain syntax for dropping triggers?

920

---

Working with TLogs

1828

---

How many database files are there in sql server 2000?what are they?

1044

---

What is the server name in sql server?

997

---

What is the sql case statement used for?

1087

---

What the class forname () does?

1051

---

What is sql server replication? : sql server replication

972

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1067

---

How to enter comments in transact-sql statements?

933

---