Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9894 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
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is master database? : SQL Server Architecture
What samples and sample databases are provided by microsoft?
What is the difference between a primary key and a unique key? Are they the same?
Which are the third-party tools used in sql server and why would you use them?
How to add an address record into adventureworkslt?
Write a code to select distinct records without using the DISTINCT keyword.
Explain the cursor lock types?
What are null values in ms sql server?
How to list all login names on the ms sql server?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to change the password of a login name in ms sql server?
Explain what is log shipping?
Define compound operators?
Why normalization is used?
