Answer / karthick.r

the query to display a particular record for the emp'v4290'
is given below

select * from employee where empid="v4290";

in this eg employee is the table-name and v4290 is the value
for the attribute empid. where is the clause to fetch the
record from the backend database table

Answer / r

SELECT * FROM TABLE WHERE(rowid=N)

What is the primary use of the model database?

0 Answers  

---

Mention the different types of triggers?

0 Answers  

---

What are clustered and non-clustered index?

0 Answers  

---

Can we call future method from queueable?

0 Answers  

---

Why the trigger fires multiple times in single login?

0 Answers  

---

Explain try...catch with sql server?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

How to create a large table with random data for index testing in ms sql server?

0 Answers  

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---

What is change data capture (cdc) in sql server 2008?

0 Answers  

---

What do you think of this implementation? Can this be implemented better?

0 Answers  

---