Answer / madhu

We can get date, month and year seperately from the
current date like

select DATEPART(d, getdate()) to get current date
select DATEPART(mm, getdate()) to get current month
select DATEPART(yy, getdate()) to get current year

Answer / aravazhi

select month(getdate()) Curr_Mon,Year(getdate())
Curr_Year,day(getdate()) as Curr_day

Answer / dharmendra k. dixit

We can do that by writing our query in this way..

Select datename(dd, getdate()) for Date
Select datename(mm, getdate()) for Month
Select datename(yy, getdate()) for Year

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

How to use transact-sql statements to access the database engine?

0 Answers  

---

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

---

IN Vs OR operator which is best to use sql server.

4 Answers  

---

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

---

Explain what is lock escalation?

0 Answers  

---

What is index, cluster index and nonclustered index?

0 Answers  

---

Explain what is use of dbcc commands?

0 Answers  

---

How to find tables without indexes?

0 Answers  

---

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

2 Answers   Shriram,

---

Explain the microsoft sql server delete command? : SQL Server Architecture

0 Answers  

---

Which database stores information about replication?

0 Answers  

---