how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

0 Answers  

---

What is difference between stored procedure and user defined function?

0 Answers  

---

What are the acid properties?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

Explain transaction server explicit transaction?

0 Answers  

---

What is difference between count (*) and count 1?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What is the purpose of the tempdb database?

0 Answers  

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  

---

How many non clustered indexes there can be on table ?

0 Answers  

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  

---