- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
--...END OF STORED PROCEDURE...
-- WORK Table
DELETE FROM S_CLD011
DELETE FROM S_COLOR
DELETE FROM S_CONTRACT
DELETE FROM S_CONVERT
DELETE FROM S_DEALER
DELETE FROM S_DIV021
DELETE FROM S_HISTORY
DELETE FROM S_LOOKUP
DELETE FROM S_MODEL
DELETE FROM S_OPTION
DELETE FROM S_PAYINV
DELETE FROM S_PIV011
DELETE FROM S_PIV021
DELETE FROM S_PRICE
DELETE FROM S_PORT
DELETE FROM S_REG075
DELETE FROM S_SDS021
DELETE FROM S_SERIES
DELETE FROM S_SIS021
DELETE FROM S_STATUS
DELETE FROM S_SUPPLIER
DELETE FROM S_SYS021
DELETE FROM S_USER
CLOSE c1
DEALLOCATE c1
CLOSE c1V
DEALLOCATE c1V
CLOSE c2
DEALLOCATE c2
CLOSE c2V
DEALLOCATE c2V
а таблички так в базе и висят... куча пустых табличек
guest 20.11.2009 13:13 # 0
Junior 20.11.2009 13:20 # 0
жаль вот только, что система давным давно сдана и во всю используется
foxweb 20.11.2009 13:16 # 0
Junior 20.11.2009 13:22 # 0
guest 20.11.2009 23:41 # +0.2