we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz
- 6 Answers
- 8645 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
FOR SQL 2005:
select datediff (day, birthdate, getdate())/365 from emp
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is a non clustered primary key?
How to execute the cursor queries with "open" statements?
You want to use a perspective in an mdx query. How do you select the perspective?
What is the maximum size per database for sql server express?
What is the difference between a clustered index and a non-clustered index?
What is the security model used in sql server 2005?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
How to insert and update data into a table with "insert" and "update" statements?
What are secondary xml indexes?
What is database white box testing?
Can we write ddl in trigger?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
