Answer Posted / gk
Adding to the above answer truncate may or may not be
rolled back.
It can be rolled back if it is within a transaction.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to create new tables with "create table" statements in ms sql server?
What are the differences between char and nchar in ms sql server?
What is triggers and stored procedures?
What is cursors? And what are the different types of cursor?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What are the advantages of mirroring?
What is the sql case statement used for?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Write a code to select distinct records without using the DISTINCT keyword.
What is the data type of time?
What is Service Broker in sql server 2012?
How to delete duplicate rows?
What are the limitations/drawbacks or ssrs 2008 r2?
What is the New in SQL server 2008?
What is the significance of master, tempdb and model databases?