What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 Answers  

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

0 Answers  

---

What are the types of database schema? : sql server analysis services, ssas

0 Answers  

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

Explain microsoft sql server functions?

0 Answers  

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

explain query execution plan

1 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

Plz tell about backup&recovery?

3 Answers  

---

Which are the important points to note when multilanguage data is stored in a table?

0 Answers  

---