Answer Posted / foram

select month(getdate())
select month(dateparametername) from tablename
---here u will get number of month
or

select datename(month,getdate())
select datename(month,dateparametername) from tablename
to get name of month

What is a derived table?

929

---

Which are the two editions in which SQL Azure database available?

119

---

How to retrieve error messages using mssql_get_last_message()?

1054

---

Is it possible to have clustered index on separate drive from original table location?

967

---

What are the requirements for sql server 2016?

883

---

What is an index in sql?

1006

---

How to restore performance issues and how to check?

2004

---

Tell me what do you understand by a view? What does the with check option clause for a view do?

1021

---

How do I perform an unattended install of sql server 2000?

1086

---

what kind of lan types do you know? : Sql server database administration

980

---

How to get @@error and @@rowcount at the same time?

1035

---

Can I save my report as html, excel or word? : sql server management studio

955

---

What is table value parameters (tvp)?

1102

---

can SSRS reports Cache results?

147

---

Can a function call a stored procedure in sql server?

962

---