12 2012 档案

摘要:--得到数据库中所有用户表 Select [name] from sysObjects Where xtype='U'and [name]<>'dtproperties' Order By [name] --得到数据库中所有用户视图 Select [name] From sysObjects Where xtype='V' And [name]<>'syssegments' And... 阅读全文
posted @ 2012-12-20 14:22 忙碌在路上 阅读(763) 评论(0) 推荐(0)
摘要:select c_gcode,c_barcode,c_name,c_price_disc,c_price,c_status from tb_gds where ( c_price like '%._[1,2,3,4,5,6,7,8,9]%' or c_price_disc like '%._[1,2,3,4,5,6,7,8,9]%' )and c_weigh='否' and c_stat... 阅读全文
posted @ 2012-12-12 09:45 忙碌在路上 阅读(2238) 评论(0) 推荐(0)