resetsystem.txt

来自「< 飞鸿商品>>零售是基于VB+SQL2000开的商品零售管理」· 文本 代码 · 共 28 行

CREATE PROCEDURE resetsystem  AS

DELETE FROM back_index
DELETE FROM back_list
DELETE FROM back_tmp
DELETE FROM client_list
DELETE FROM foot_history
DELETE FROM ruku_index
DELETE FROM ruku_list
DELETE FROM sell_index
DELETE FROM sell_list
DELETE FROM yaopin_cost
DELETE FROM yaopin_list
DELETE FROM yaopin_num
DELETE FROM yaopin_price
DELETE FROM yaopin_types
DELETE FROM yaopin_unit
DELETE FROM yaopin_alter_stock
DELETE FROM yaopin_alter_cost
DELETE FROM yingfu_history
DELETE FROM yingfu_list
DELETE FROM stock_back
DELETE FROM [user]

INSERT INTO [user] VALUES ('系统管理员','sa','系统管理员')
UPDATE sysset SET syscaption='' ,printhat='', printend='', isprint=1
GO