程序春秋
关注
分享
扫一扫
xiangsu
这个作者很懒，什么都没留下…
展开
-
transaction 應用
begin tran/*** SQL ***/if @@error>0 rollback tranelse commit tran原创 2005-09-13 11:05:00 · 977 阅读 · 0 评论 -
在SQL中操纵EXCEL
SELECT * FROM OpenDataSource( Microsoft.Jet.OLEDB.4.0, Data Source="c:/M.xls";User ID=admin;Password=;Extended properties=Excel 5.0)...[Sheet1$]原创 2005-09-13 10:56:00 · 995 阅读 · 0 评论 -
2段SQL效能比較
--SEQ_A:select A.* from t_brdl_acry_prog A,t_brdl_acry_deta Bwhere A.acry_seq_no=B.acry_seq_no and A.acry_no=M022591 and A.out_box is not nulland A.acry_seq_no not in (select distinct isnull(acry_s原创 2005-09-13 11:04:00 · 1408 阅读 · 0 评论