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
- 8654 Views
- I also Faced
- E-Mail Answers
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
What happens if null values are involved in arithmetic operations?
What is extent? Types of extents?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How to create new tables with "create table" statements in ms sql server?
What is a domain constraint give an example?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Explain logical operators in sql server?
Difference between LEN() and DATALENGTH() in sql server ?
Explain what is lock escalation and what is its purpose?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What are the five characteristics of good data?
How do you create type- insensitive operator?
What is the difference between NOROW and LOCKROW?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is temporary table in sql server? Why we use temp table?
