ITPub博客

DECLARE test_cursor CURSORFOR select id,name from invest..sysobjects where OBJECTPROPERTY(id, N'IsView') = 1 and name not like 'sys%'DECLARE @name varchar(100)declare @id intDECLARE @SQLSTR varchar(4000)OPEN test_cursorFETCH NEXT FROM test_cursor INTO @id,@nameWHILE (@@fetch_status <> -1)BEGIN BEGIN set @sqlstr='drop view '+@name select @sqlstr select 'go' --select text from sysobjects o,syscomments c where o.id=c.id and xtype='V' and name not like

ORACLE:sqlplus user/password@SID "d:test.sql"SQL SERVER:osql -S servername -U user -P password -i "d:test.sql"[@more@]

select substr('asdefeeffb',(instr('asdefeeffb','f',-1)-1)-length('asdefeeffb')) from dual[@more@]

Oracle Date Function 讲解和事例请大家记住 1 year=1*12 months1 day=24 hours=24*(1*60mins)=24*60*(1*60 seconds)1 week =7 days注意：黑色字体是 oracle 8i，9i都可以使用的函数，蓝色字体是 Oracle9i新增的部分。请大家在使用时，注意版本限制。add_monthscurrent_datecurrent_timestampdatimezoneextract(datetime)last_daymonths_betweennew_timenext_dayroundSYSDATEsystimestampTO_DATEtrunc()1： Add_Months 语法： Add_Months(d,n) 函数 -- n可正可负 作用： Add_Months(d,n) 返回日期 D 加上n 月的日期Example:A：下个月的今天

log_archive_dest_1 = "location=E:oracleoradatamisarchive reopen=2"[@more@]

SMSDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.190.9.241)(PORT = 1521)))(CONNECT_DATA =(SID = smsdb)(SERVER=DEDICATED)))[@more@]