What is difference between delete and truncate commands?
No Answer is Posted For this Question
Be the First to Post Answer
How to end a stored procedure properly in ms sql server?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
How to grant a permission in ms sql server using "grant execute" statements?
What is BLOCK statements in SQL?
Define the term DML, DDL and DTL?
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
What is difference between after and before?
Explain user defined views?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What is database mirroring?
What are commit and rollback in sql?