Answer / nadiya

TRUNCATE DELETE DIFFERENCE

Truncate command will delete all records and the most
important thing to make note of

truncate command is since truncate command cannot be rolled
back one must make
sure to take proper backup of table data before performing
the truncate command.

Truncate command is thus used to remove all rows from
either a table or a cluster.

If one wants to use the truncatecommand in a cluster they
can use
it only in an indexed cluster and not in a hash cluster.


Though the functionality of delete and truncate looks on
the outward same

the main differences between truncate and delete statements
are

truncate is a DDL statement whereas
delete is a DML statement.


Truncate command cannot be rolled back but
delete command can be rolled back.


As a result, as explained

before truncate command is faster than delete command.

Another main difference between delete andtruncate command
is

delete command can be used with a where clause to delete
specific rows from a table.

If the where clause is not specified in a delete
statement,
all rows are deleted from the table.

Thus delete command can be used to delete specific or all
rows from a table.
But truncate command deletes all rows from the table.
The general syntax of truncate command is
TRUNCATE TABLE tablename;
For instance if one wished to truncate a table named as
exforsys
it is done by using the command as follows:


TRUNCATE TABLE exforsys;

Answer / xyz

truncate basically clears the data from the rows of a
specified colomn.
e.g. truncate colomn_name from table_name
then this will only empty the colomn

delete is used to simpy delete anything from the table.
e.g. delete table_name
this will remove the whole table from the database.

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

What is sleeping status in sql server?

0 Answers  

---

What are the differences between ms sql server & oracle?

0 Answers  

---

Explain about extended stored procedure?

0 Answers  

---

Do you know how to make remote connection in database?

0 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---