how to delete duplicate rows in sql server2005
Answer Posted / pritesh
By using temporary table, But it will delete exactly
duplicate rows NOT RECOMMANDABLE FOR HUGE TABLE. Query will
be.
SELECT DISTINCT * INTO #A FROM TABLE1
TRUNCATE TABLE TABLE1
INSERT INTO TABLE1
SELECT * FROM #A
Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
What are horizontal and vertical scaling?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is data compression?
Name 3 ways to get an accurate count of the number of records in a table?
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
Explain the dirty pages?
What is indexing explain it with an example?
What is inline variable assignment?
whats the maximum size of view state??
What is index, cluster index and nonclustered index?
What are logical database components? : SQL Server Architecture
What do you understand by mirroring?
Describe in brief sql server monitoring ways.
How to modify an existing user defined function?
How to test a dml trigger in ms sql server?