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 de-normalization and what are some of the examples of it?

0 Answers  

---

Explain the disadvantages/limitation of the cursor?

0 Answers  

---

Why functions are used in sql server?

0 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

what is a stored procedure and trigger?

3 Answers  

---

What is a transact-sql statement batch in ms sql server?

0 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

What are rows and columns?

0 Answers  

---

What is an indexing strategy?

0 Answers  

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---