jzu

原帖由 bigmonster 於 2008-10-22 09:09 發表


如果係oracle DB,  條條record 一定有 rowid , SQL Server 2005 都有同樣的field , 不過叫  Row_Number()

你有冇寫過DB program 架, 咁都唔知???

window function好似唔可以用係 delete statement

rocketdive04

原帖由 jzu 於 2008-10-22 09:55 發表


window function好似唔可以用係 delete statement

what do you mean by window function?
delete statement you can write it on stored procedure

jzu

原帖由 rocketdive04 於 2008-10-22 10:46 發表


what do you mean by window function?
delete statement you can write it on stored procedure

nothing la, 你當我無講過啦

henrywho

search for "SQL window functions" in google....