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

How to create a large table with random data for index testing in ms sql server?

532


What is difference between temp table and cte?

528


What is the use of RDBMS?

583


Why functions are used in sql server?

502


Explain how to integrate the ssrs reports in application?

516






When would you use it?

574


What are the steps you can take to avoid “deadlocks”?

518


Explain different types of Normalization.

593


What is a trigger? Why we need it?

529


What is user-defined multi-statement table-valued function?

653


Are all views updatable ?

718


What is an expression in ms sql server?

563


What is ddl and dml commands?

507


Do you know what is normalization of database? What are its benefits?

555


Explain indexing and what are the advantages of it?

520