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...

How to get number of days in a given year?

Answer Posted / koppalahareesh

declare @y int;
set @y = 2016;

SELECT DATEDIFF(day,cast(@y as char(4)), cast(@y+1 as char(4))) Days

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use non clustered index?

1010


How to access the deleted record of an event?

978


Define Wed Edition in SQL Azure?

100


Do you know what is rank function?

1035


What do you understand by recursive stored procedures?

940


How ssrs maintain security?

1018


How to get all stored procedures in sql server?

939


Why should you use or avoid select * statements?

969


Explain rdbms?

982


What are the 7 disadvantages to a manual system?

909


Can coalesce return null?

948


What are key constraints?

929


What does ss stand for sexually?

1011


What command do we use to rename a db, a table and a column?

876


What is a natural primary key?

951