Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38394 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / agnel
* A truncate removes all rows from a tablethat operation
cant be rolled back.
* A drop command removes a table from a database all the
tables rows indexes and privilleges will also be removed.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the essential components of sql server service broker?
Explain in details security in SQL azure?
What is difference between inner join and join?
How to list all login names on the ms sql server?
Explain error handling in ssis?
What is index, cluster index and nonclustered index?
Differentiate between a having clause and a where clause.
Why use “nolock” in sql server?
What is difference between getdate and sysdatetime in sql server 2008?
What is difference between clustered index and non clustered index?
What is optimization and its types?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
what is nonclustered index
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Where cross join is used?
