What is storeprocedure?Tell me synatx for how to write stored procedure.

1 Answers   Cap Gemini,

---

What is 2nf normalization?

0 Answers  

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

---

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

---

Call by value and call by reference in procedure and function, with NOCOPY.

0 Answers   Nagarro,

---

How to create a dml trigger using create trigger statements?

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

Explain the third normal form(3nf)?

0 Answers  

---

How make remote connection in database?

1 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  

---

State a few properties of relational databases?

0 Answers  

---

What is etl - extraction, transformation, and loading?

0 Answers  

---