What are the fixed server level roles? : sql server security

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What is recompile sql server?

0 Answers  

---

Do you know what is a with(nolock)?

0 Answers  

---

How does recursive cte works in sql server?

0 Answers  

---

Please illustrate physical database architecture? : SQL Server Architecture

0 Answers  

---

Explain about unique identifier data type in sql server?

0 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

What is the recovery model?

0 Answers  

---

From where can you change the default port?

3 Answers  

---

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

What is the difference between set and select?

0 Answers  

---