Answer / sandhya

SELECT DATEDIFF(DD,HIREDATE,GETDATE())

Answer / koppalahareesh

declare @y int;
set @y = 2016;

SELECT DATEDIFF(day,cast(@y as char(4)), cast(@y+1 as char(4))) Days

Answer / dinesh rathod

would like to get the total number of days in a year left from the given

Answer / pulak

select add_months(trunc(sysdate,'year'),12)-trunc(sysdate,'year') as days from dual;

What is public role in sql server?

0 Answers  

---

What is the purpose of update statistics and scope_identity() function?

0 Answers  

---

What is the maximum size of column in sql server?

0 Answers  

---

What are the advantages dts has over bcp?

0 Answers  

---

How to create new table with "create table" statements?

0 Answers  

---

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

---

Explain the use of containers in ssis and also their types?

0 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---

What are views in ms sql server?

0 Answers  

---

How do I find the sql server version?

0 Answers  

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---