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 / sandhya

SELECT DATEDIFF(DD,HIREDATE,GETDATE())

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is best institute to Learn DotNET And SQL in chennai?

2219


if no size is defined while creating the database, what size will the database have? : Sql server administration

1059


What is a cursor, index in sql?

1126


What is the difference between cube operator and rollup operator? : SQL Server Architecture

1169


How to transfer data from a cursor to variables with a "fetch" statement?

1141


How to verify a user name with sqlcmd tool?

1118


Can you explain various data region available in ssrs with their use?

1020


Do you know what guidelines should be followed to help minimize deadlocks?

1014


Can truncate be rolled back?

989


what are candidate key, alternate key and composite key? : Sql server database administration

962


Differentiate between delete and truncate.

1110


what do you understand by change data capture?

1077


What method is used by the Command classes to execute SQL statements that return single values?

1114


What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1100


What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

937