Answer Posted / rajesh k. gupta

Hi,
In order to answer your question I would like to put all
three possible answers as follows:-

1.If You want to find out the age of employee as on the
date of Joining (Field name EDOJ) then Query will be

select *,datediff(year,EDOB,EDOJ) as Eage from emp

2. If you want to find out the age of employees as on
current date, query will be as follows:-

select *,datediff(year,EDOB,getdate()) from emp

3. If you want to find out age as on specific date stored
and taken from other variable then query will be :-

You need to declare a variable as datetime then need to
tore its value to it.

declare @dtb datetime
set @dtb='1990/01/10'
select *,datediff(year,EDOB,@dtb) from emp
---------------------------------------
For any clarification Please feel free to contact me.
Rajesh
9342284359

How can you set the threshold at which sql server will generate keysets asynchronously?

1052

---

Explain the database you used in your final year project?

1103

---

What command is used to rename the database?

1086

---

Describe how to use linked server?

1079

---

Do you know what are the reporting services components?

1020

---

Why de-normalization required?

1055

---

How to deploy the Report?

140

---

What is join query?

938

---

Explain index in sql server?

1066

---

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1127

---

How to create a dynamic cursor with the dynamic option?

1103

---

What are a scheduled jobs or what is a scheduled tasks?

944

---

What are the advantages of user defined function?

1042

---

Explain log shipping?

1078

---

What is the main purpose of having conversation group?

947

---