hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  

---

what is the maximum size of sql row in mssql?

1 Answers  

---

Mention the differences between substr and charindex in sql server.

0 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

Do you know what are the restrictions that views have to follow?

0 Answers  

---

How to check parameter value in stored procedure sql server?

0 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

How to create user messages with print statements in ms sql server?

0 Answers  

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

What are distributed partitioned views?

0 Answers  

---

What is a job?

3 Answers  

---