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

What stored by the model?

1049


What is the difference between a check constraint and a rule?

1237


Do you know hot add cpu in sql server 2008?

950


What is the main purpose of having conversation group?

896


What is an identity column in insert statements?

1016


How to store and query spatial data?

984


Can sql servers linked to other servers?

1031


Where are sql server user names and passwords stored in sql server?

1080


Is INSTEAD OF trigger directly applicable to Table ?

1009


What is the use of tempdb? What values does it hold?

1068


How to use go command in "sqlcmd"?

1200


Determine how to use the inserted and deleted pseudo tables?

985


How to locate and take substrings with charindex() and substring() functions?

1014


What are the methods used to protect against sql injection attack?

1058


What are the purposes and advantages stored procedure?

950