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
How many non clustered indexes there can be on table ?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What is the importance of a recovery model?
What is sql azure database?
What are the types of resultset?
Can you import Microsoft Excel data to SSRS?
What is the difference between inner join and equi join?
Why we should not use triggers?
What is difference between delete and truncate commands?
how can u get last observation in an unknown dataset ?
Can we use where and having clause together?
What is model database in sql server?
List the different types of collation sensitivities in sql server?
What is abstracting periodical?
Explain sql server authentication modes?