Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aman sharma
truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What kind of problems occurs if we do not implement proper locking strategy?
Does table partitioning improve performance?
What are the different types of stored procedures?
Why olap is used?
How do you create an execution plan?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
What is difference statement and preparedstatement?
What is built-in/administrator?
What is difference between rownum and row_number?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is failover clustering overview?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Is mysql the same as sql server?
What is in place upgrade in sql server?
What is the difference between stored procedure and functions?
