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)

explain different types of cursors? : Sql server database administration

0 Answers  

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

What are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is sql server management studio? : sql server management studio

0 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

Diffrent types of function

1 Answers   Wipro,

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

If the job running very slow what is the action you do

0 Answers  

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...

7 Answers   Value Labs,

---

what are user defined datatypes? : Sql server database administration

0 Answers  

---