Explain syntax for viewing trigger?

0 Answers  

---

What is microsoft sql server?

0 Answers  

---

Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem

2 Answers  

---

What is the process of normalising?

0 Answers  

---

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

---

What is set nocount on?

0 Answers  

---

Explain “not null constraint” in sql server?

0 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

What is a Trace frag?Where can we use this?

1 Answers  

---

Explain the various types of concurrency problem?

0 Answers  

---