Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to get number of days in a given year?

Question Posted / rajkumar

Answer Posted / rajkumar

DECLARE @IsLeapYear        BIT




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




    select 365 + @IsLeapYear

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for encrypting a column in SQL Server?

1175

How to create indexed view?

1106

How can we check the sql server version?

1128

Explain what is the difference between a local and a global temporary table?

1047

What the different components in replication and what is their use?

998

How to include text values in sql statements?

1098

What is a view in sql?

1022

What is the default value of an integer data type in sql server 2005?

995

Is candidate a key?

1002

What is view in sql?

953

What are different types of data sources?

1084

What is the process of indexing?

1053

What is normalization? What number of normalization shapes are there?

1159

Do comments need to go in a special place in sql server 2005?

913

What is ssl in sql server?

1134