Which sql server table is used to hold the stored procedure script?

0 Answers  

---

what is isolation level at dead lock?

0 Answers   Verizon,

---

Can a table be moved to different filegroup?

0 Answers  

---

I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30

13 Answers   DELL,

---

What is Cross Join

3 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  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

How to transfer an existing table from one schema to another schema in ms sql server?

0 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

What are the database roles? : sql server security

0 Answers  

---

How to join two tables in a single query in ms sql server?

0 Answers  

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---