sql常用语法（SQL common syntax）.docVIP

sql常用语法（SQL common syntax） - 1、初始1号工密码 Update admin _ Operator Set Oper _ PW = null where Oper _ id = 1001; - 2, 延长试用期 Update Manager zmvc _ Set Start _ day = null, End _ day = null; - 3, 清除帐套密码: Delete from System _ role - 4, 会员卡档案里面的所有卡都参与积分 Update pos _ VIP _ message set is _ integral = 1 (把1改为0就不积分了) - 4经营圣手批发销售单, 每页打印合计的大写公式: (F _ pub _ Money _ RMB (SUM (price * real _ round out _ qnty, 2) for page) + 0) - 经营圣手是否有库存管理 Update base _ entry _ message Set have _ stock = 1 where have _ stock = 0 说明: 1是管库存, 0是不管库存, 管库存执行语法后然后到商品档案的辅助信息界面中把商品品态改成进销! - 去掉127条码和货号前三位 (0102是类别代码, 修改的时候根据类别来修改) Update base _ entry _ message Set item _ subno = Substring (Item 4, _ subno, Len (Item _ subno) - 3) where Substring (Item 1.3 _ subno, and item 127) = = _ clsno 0102 Based _ entry Update message set _ Barcode = Substring (barcode, 4, Len (Barcode) - 3) where Substring (barcode, 1.3) = and item 127 _ clsno 0102 = - 多少元积一份 (20代表多少元积一分, 0102是代表那一个分, 修改的时候根据类别来修改相应的积分率) Update base _ entry _ message Set Comprehensive _ rate = 20 where item _ clsno 0102 = - 是否可以打折 (零表示不打折, 改为1就打折, 0102, 是类别代码, 修改的时候根据类别来修改) Update base _ entry _ message Set allow _ discount = 0 where item _ clsno 0102 = - 会员重算积分语法 (后面的5表示多少元积一分) Update message set _ pos _ VIP VIP VIP _ integral = _ built _ amount / 5 - 修改商品档案的积分按照参数设置积分 (- 1); 不积分 指定多少元积1分 (0) (1); Update base _ entry _ message Set Comprehensive _ rate = 1 - 执行下列语法后, 重新进入后台就可以了 Update System _ System set _ _ sys var value = where _ _sys var id = Finally _ uptime - 经营圣手会员积分标志 Update pos _ VIP _ message set is _ integral = 1 - 修改生鲜档案 Update base _ entry _ message Set item _ flag = 1 where item _ clsno 类别代码 = - 去掉生鲜前面两位数21 Based _ entry Update message set _ Barcode = Substring (barcode, 3, Len (Barcode) - 2) where Substring (barcode, 1.2) = 21 and item _ clsno 类别代码 = - 货号等于条码 Update base _ entry _ message Set item _ subno = Barcode where item _ clsno 类别代码 = - 货号加长语法 Update base _ entry _ message Set item _ subno = + _ subno item 88 - 修复