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 a file group?

1084

Where the sql logs gets stored?

980

Do you know what are different types of replication in sql server?

1088

What are different types of statement?

1006

Why truncate is ddl command?

1057

What are the advantages of log shipping?

992

How to rename databases in ms sql server?

1191

what are the core components of SSRS?

129

Explain the difference between primary keys and foreign keys?

1016

What is save transaction and save point?

1197

What is the query and subquery?

1072

What is the rdl file?

138

Explain external key management in sql server 2008

883

Can sql server 2016 run on windows 7?

910

Explain about link server in sql server?

1050