we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz

Answer Posted / rajesh k. gupta

The answer submitted by Santhi K is wrong, Can shanti test
this query in sql server, because i ran it it does not
accept. there is no such months_between function

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to provide values to user defined function parameters?

553


When do you think a developer should use sql server-based cursors?

518


How to include text values in sql statements?

580


Explain comment on transactions?

551


What do you mean by data manipulation language?

583






How to replace given values with null using nullif()?

572


What are different types of views?

547


Can a cursor be updated? If yes, how you can protect which columns are updated?

515


How to set database to be single_user in ms sql server?

559


How to execute function in stored procedure sql server?

535


Difference between aggregate functions of sql?

649


what's the difference between delete table and truncate table commands? : Sql server database administration

479


What is a partition function in sql server?

535


What does this statement do @@rowcount?

543


How to delete database objects with "drop" statements in ms sql server?

589