What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

---

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

---

What is Index ? Explain its Types?

2 Answers   ADP,

---

can a database be shrunk with users active? : Sql server administration

0 Answers  

---

How can delete duplicate records in cte in sql server?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

How get current date in SQL server 2000

6 Answers   Cap Gemini,

---

Is a primary key unique?

0 Answers  

---

Differences between Standby Vs No recovery?

2 Answers   Wipro,

---

What are the five characteristics of good data?

0 Answers  

---

Anyone please explain me the concept of Serialization?

3 Answers  

---