Answer / Mayank Gupta

In SQL Server, there are several types of statements including SELECT (used for querying data), INSERT (used for inserting data into tables), UPDATE (used for modifying existing data), DELETE (used for deleting data), CREATE (used for creating database objects like tables and indexes), ALTER (used for changing the properties of existing database objects), and DROP (used for removing database objects).

What are the differences between char and nchar in ms sql server?

1 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1 Answers  

---

What is the sql server agent?

1 Answers  

---

What is the order in which the sql query is executed?

1 Answers  

---

Explain the stored procedure?

1 Answers  

---

Explain the dirty pages?

1 Answers  

---

What is merge?

1 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

How to choose all records from the table?

1 Answers  

---

Explain indexes disadvantages?

1 Answers  

---

What is data mart? : sql server analysis services, ssas

1 Answers  

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---