how to add the unique index while there are duplicate row in the table?

1> declare delete_duplicate_catalog cursor for

select id from catalog_5_4

for update
2> 3> 4> 5> 6>
7> go
1> open delete_duplicate_catalog
2> go
Msg 311, Level 16, State 1:
Line 3:
The optimizer could not find a unique index which it could use to scan 
table
'catalog_5_4' for cursor 'delete_duplicate_catalog'.
1>
0
dnas163
5/4/2001 10:14:03 AM
sybase.sqlserver.admin 2338 articles. 0 followers. Follow

0 Replies
738 Views

Similar Articles

[PageSpeed] 28

Reply: