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 multilevel indexing?

902

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2333

---

Can we join two tables without primary key?

992

---

How you would rewrite the sql query to return the customerid sorted numerically?

953

---

Explain what is it unwise to create wide clustered index keys?

942

---

How to create an index on an existing table in ms sql server?

939

---

How to delete duplicate records based on single column from a table?

1008

---

How can we solve concurrency problems?

1007

---

What is sub-query in sql server? Explain its properties.

1051

---

What are the types of database schema? : sql server analysis services, ssas

1083

---

Describe in brief authentication modes in sql server.

983

---

Do you know hot add cpu in sql server 2008?

908

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

965

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

998

---

What are the different types of replication you can set up in sql server?

1001

---