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 are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5495


How to move database physical files in ms sql server?

527


Does an index slow down updates on indexed columns?

577


What is used to replicate sessions between instances in coldfusion clusters?

578


Tell me what is a linked server?

562






Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

584


Can primary key be null?

511


What are partitioned views and distributed partitioned views?

600


Does group by sort data?

511


Why de-normalization required?

569


Can a table be created inside a trigger?

561


Does index speed up select statements?

581


Explain transaction server explicit transaction?

502


How many types of database relationship in sql server?

561


How can I track the changes or identify the latest insert-update-delete from a table?

535