Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / v.krishnakumar
in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What happens when converting big values to integers?
Do you know what is rank function?
Where is localdb stored?
What stored by the model?
Explain transaction isolation levels in sql server?
What is a partition function in sql server?
What are the different types of data sources in ssrs?
When does a workload on SQL Azure get throttled?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What is linked report?
Explain the microsoft sql server delete command? : SQL Server Architecture
What is #temp and @table variable in SQL server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
You want to use a perspective in an mdx query. How do you select the perspective?
