Answer Posted / kiran kumar

update command is used to modify the existing column by
using where clause...
if we dont use the where the enitire columns in the table is
updated...

How to write a query to show the details of a student from students table whose

755

---

which tcp/ip port does sql server run on? : Sql dba

706

---

what are the types of subquery? : Sql dba

768

---

What does trigger mean in psychology?

708

---

How does one load ebcdic data? : aql loader

827

---

---

How can we solve sql error: ora-00904: invalid identifier?

885

---

Is primary key clustered or nonclustered?

741

---

explain the difference between myisam static and myisam dynamic. : Sql dba

705

---

What is a data manipulation language?

745

---

What is the largest value that can be stored in a byte data field?

709

---

How do I find sql profiler?

683

---

What is the difference between null value, zero, and blank space?

768

---

Explain some predefined exceptions.

778

---

What is sql performance tuning?

650

---

Can we enter data in a table in design view?

714

---