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 the use of attributehierarchyvisible ? : sql server analysis services, ssas

561

---

What is the difference between locking and multi-versioning?

520

---

How to set database to be single_user in ms sql server?

553

---

what is raid? : Sql server database administration

545

---

What information is maintained within the msdb database?

531

---

---

What is data source object?

542

---

Explain transaction server explicit transaction?

498

---

What are the encryption mechanisms in sql server?

568

---

How do clustered indexes store data?

603

---

Difference between report and query parameter.

590

---

What happens when converting big values to integers?

562

---

How can you hide the sql server instances?

506

---

What is change data capture (cdc) feature?

576

---

How to receive output values from stored procedures?

470

---

what stored procedure can you use to display the current processes? : Sql server administration

525

---