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

Explain trigger and trigger types?

905


What are the ways available in sql server to execute sql statements?

1036


What is 3nf normalization?

924


What are data resources?

852


Can we insert data if clustered index is disabled?

889


How to disable a login name in ms sql server?

1058


Explain the stored procedure?

987


why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

972


Explain system functions or built-in functions? What are different types of system functions?

914


Explain “row_number()” in sql server with an example?

947


What is explicit mode in sql server?

1015


What are the High-Availability solutions in SQL Server and differentiate them briefly?

1087


What are statistics?

946


Write a SQL query to delete a table?

1077


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1145