Answer Posted / ashis

update <tablename> set <columnname>=<value>
where <condition>

What is the difference between executequery () and executeupdate ()?

1007

---

Can group by and orderby be used together?

993

---

Where are sql server user names and passwords stored in sql server?

1065

---

Can sql servers linked to other servers like oracle?

928

---

What is importing utility?

962

---

How do you make a trace?

997

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1049

---

What are the functions in sql server?

936

---

What is a self join in sql server?

1108

---

How do I find the port number for sql server?

953

---

How to create a user to access a database in ms sql server using "create user" statements?

936

---

Why it is recommended to avoid referencing a floating point column in the where clause?

948

---

Which autogrowth database setting is good?

1034

---

What is user defined stored procedures?

905

---

Describe the left outer join & right outer join. : sql server database administration

984

---