Answer / poornima k

create table &t_name(&f_name1 &datatype1);

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

Does server sql treat char as a variable-length or fixed-length column?

0 Answers  

---

what are triggers? : Sql server database administration

0 Answers  

---

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

---

What are different types of replication in sql server?

0 Answers  

---

Is there any difference between primary key and unique with the not null condition?

0 Answers  

---

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

2 Answers   Sparsh,

---

Do you know what are pages and extents? : SQL Server Architecture

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

How to delete existing triggers using "drop trigger"?

0 Answers  

---