What is the difference between truncate and delete statement?
Answer Posted / rajiv singh
Truncate deletes all rows from table. But Delete deletes
row/rows by condition.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain how to use linked server?
Explain iaas, paas and saas?
What happens if null values are involved in bitwise operations?
can you instantiate a com object by using t-sql? : Sql server database administration
Can binary strings be converted into numeric or float data types?
How to find table changes in sql server?
What is the difference between value type and reference type?
What is the difference between varchar and nvarchar datatypes?
Can two different columns be merged into single column? Show practically?
Is the primary key column of a table an index in ms sql server?
What is sql server agent and what are the two modes of authentication in sql server?
Explain primary key in sql server?
What are scalar functions in sql?
What is the difference between executequery () and executeupdate ()?
What are date and time data types in ms sql server?