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
How would we use distinct statement? What is its use?
How to find the service pack installed? : sql server database administration
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Can you explain about buffer cash and log cache in sql server?
what is a schema in sql server 2005? : Sql server database administration
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is difference between oltp and olap?
What are the different types of replication are there in sql server 2000?
How to filter out duplications in the returning rows in ms sql server?
How important do you consider cursors or while loops for a transactional database?
What are user-defined functions (udfs) in sql server?
Explain what is raid and what are different types of raid levels?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is acid db?
System variable and temporary variables
