中国鱼----ChineseFish的专栏

在sql server 2000 中,创建bat执行sql,方法一,使用查询分析仪isqlw -Usa -P -ic:/脚本.sql -oc:/Log.txt方法二:@echo   isql   create   job   start>>log.txt  isql   -Usa   -P123   -S(local)   >log.txt  @echo   isql   create   job

select Ninsert into code_segment(FPREFIX,FPROVINCE,FZONECODE,FZONE,FNUMTYPE,FPVDID,FSYNCFLAG) values(+fprovince+,+fprovince+) from tmp_code_segment where fprefix=130

1.update   id   set   (a,b,c)=(select   a,b,c   from   ida   where   ida.id=id.id);2.update   id   t1   set   a=(select   t2.a   from   ida   t2   where   t1.id=t2.id),b=(select   t2.b   from  

日期时间转字符串Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06 Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16 Select CONVERT(varc

declare V_param1 char(20) :=;--length(V_param1)=20;declare V_param2 varchar2(20):=;--length(V_param2) is null;declare V_param3 nvarchar2(20) :=;--length(V_param3) is null; V_param1 :=V_p

定义：CURSOR C_QGCSMO IS     SELECT T.FPROVINCE, COUNT(1) MOCOUNT       FROM SMSBILL.BILLINGTABLE@D3BILL T      WHERE T.FUD IN (a, A)        AND T.FMASTER = 054        AND T.FMSGTYPE =

fmobile输入参数，msg输出参数 --方法1 variable msg varchar2(100)variable fmobile varchar2(100):=13424242890exec smsrun.PKG_SETNEIZHI.p_Whynomt(fmobile,msg)print msg --方法2set serveroutput on;