Answer Posted / pavan kumar

Mr. Chandran, I tried your query but the system is throwing
error message as 'Incorrect syntax near the
keyword 'group''.

Mention the differences between sql server and mysql.

1084

---

What is db stored procedure?

943

---

Explain for xml explicit mode?

1024

---

Can group by and orderby be used together?

1069

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1151

---

How can you know if the row fetched from cursor is still valid in underlying table?

1044

---

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

996

---

What command would you use to add a column to a table in sql server?

1356

---

How does using a separate hard drive for several database objects improves performance right away?

988

---

How can you check the version of sql server?

1158

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1020

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

1010

---

Explain about remote stored procedure?

1060

---

What is difference between delete & truncate commands?

1140

---

What is Dependency Injection and provide example?

1178

---