Answer Posted / sharifuddin

for this first design the table like the fields as

EMPNo | EMPNAME | SALARY | DETAILS

Now write the query as follows...

SELECT * FROM EMPLOYE WHERE DETAILS LIKE '%<SEARCH KEY>%'

This is the simplest query for that...

Sharif

What’s difference between “optimistic” and “pessimistic” locking?

575

---

What parameters can you pass in the url of the api?

657

---

Describe session handling in a webfarm?

554

---

What is repository pattern in mvc.net? : asp.net mvc

522

---

What are the Types of objects in ASP

579

---

---

What are the validation controls available in ASP.NET?

540

---

Can we use a static function with a non-static variable?

505

---

Explain Life cycle of ASP.NET page when a request is made.

747

---

What is Partial PostBack in ASP.NET?

598

---

3. What goals do you have in your career?

1417

---

How do cookies work? Give an example of their abuse.

540

---

Where sessions are stored?

650

---

What are the steps to follow to host a web application on a web server?

589

---

What are the namespace classes used in asp.net mvc? : asp.net mvc

541

---

What is the difference between system.stringbuilder and system.string

255

---