ITPub博客

SQL server 阻塞

grant create procedure to [heytest]GRANT--end --change schema owner ALTER ON SCHEMA::dbo TO heytestUSEGO [heytest1]ALTERGO AUTHORIZATION ON SCHEMA::[db_owner] TO [dbo][@more@]

DECLARE @T TABLE (ID INT,NAME VARCHAR(4),STATUS INT)INSERT INTO @TSELECT 1,'aa',0 UNION ALLSELECT 2,'aa',1 UNION ALLSELECT 3,'aa',0 UNION ALLSELECT 4,'bb',1 UNION ALLSELECT 7,'bb',1 UNION ALLSELECT 9,'bb',1 UNION ALLSELECT 10,'aa',0 UNION ALLSELECT 11,'cc',0----常规语句法，此方法不要求主键连续，但假如求连续一百次的就脸长了select a.name from @t a,@t b,@t cwhere a.name=b.name and b.name=c.name and b.id=(select top 1 id from @t where id>a.id order by id) and c.id=(select top 1 id from @t where

DELETE TMP FROM (SELECT ID,MIN(STATE) STATE FROM TMP GROUP BY ID HAVING COUNT(1)>1) B WHERE TMP.ID=B.ID AND TMP.STATE<>B.STATE[@more@]

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@]

DOS 下的FOR循环 2003-06-21          阅读: 4400 for /L %%A in(1,1,254) do ping 192.168.1.%%A |find "Reply" >>ip.txt //1开始，步进=1，到254for /F %%A in (ip.txt) do arp -s %%a ///F从文件中取每一行for /D %%A in (*.*) do dir $$A // /D 取目录名[@more@]

FTP命令使用大全FTP命令是Internet用户使用最频繁的命令之一，不论是在DOS还是UNIX操 作系统下使用FTP，都会遇到大量的FTP内部命令。 熟悉并灵活应用FTP的内部 命令，可以大大方便使用者，并收到事半功倍之效。c FTP的命令行格式为： ftp -v -d -i -n -g [主机名] ，其中-v 显示远程服务器的所有响应信息；-n 限制ftp的自动登录，即不使用；.n etrc文件；-d 使用调试方式；-g 取消全局文件名。ftp使用的内部命令如下(中括号表示可选项):1.![cmd[args]]：在本地机中执行交互shell，exit回到ftp环境，如： !ls*.zip.2.$ macro-ame[args]：执

bat-任意截断替换字符 FOR /F ["options"] %variable IN (file-set) DO command [command-parameters]FOR /F ["options"] %variable IN ("string") DO command [command-parameters]FOR /F ["options"] %variable IN ('command') DO command [command-parameters]optinoseol=c           - 指一个行注释字符的结尾(就一个)//要忽略以什么字符开头的行skip=n          - 指在文件开始时忽略的行

Here u go Error: ORA 6413 Text: Connection not open.------------------------------------------------------------Cause: Unable to establish connection.Action: Use diagnostic procedures to ascertain exact problem.Solution Description--------------------You are starting the application from a directory with a special character in the name.A simple testcase:create a directory c:test(4)copy odbctst.exe to this directory and start it from this directoryyou will get the ora-6413 when trying to connect

第一章：日志管理  1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system checkpoint; 3.adding online redo log groups sql> alter database add logfile [group 4]sql> ('/disk3/log4a.rdo','/disk4/log4b.rdo') size 1m; 4.adding online redo log members sql> alter database add logfile member sql> '/disk3/log1b.rdo' to group 1, sql> '/disk4/log2b.rdo' to group 2; 5.changes the name of the online redo logfile sql> alter database rename

select * from sysserverssp_addlinkedserver 'OrclDB', 'Oracle', 'MSDAORA', 'hbmis'sp_addlinkedsrvlogin 'OrclDB', false, 'sa', 'czmis', 'mis'select top 100 * from OrclDB..CZMIS.YD_YHJBDA[@more@]