- 博客(16)
- 收藏
- 关注
RSS订阅转载 列出SQL Server里的阻塞链
点击(此处)折叠或打开 ;WITH requests (session_id, start_time, status, blocking_session...
2015-01-21 11:57:13
134
转载 Grant permission to only create/alter/drop proc
grant create procedure to [heytest]GRANT--end --change schema owner ALTER ON SCHEMA::dbo TO heytestUSEGO [heytest1...
2009-03-11 17:22:20
164
转载 求连续出现三次的某一数值的算法
DECLARE @T TABLE (ID INT,NAME VARCHAR(4),STATUS INT)INSERT INTO @TSELECT 1,'aa',0 UNION ALLSELECT 2,'aa',1 UNION A...
2009-03-09 18:11:55
312
转载 sql server 删除重复记录
DELETE TMP FROM (SELECT ID,MIN(STATE) STATE FROM TMP GROUP BY ID HAVING COUNT(1)>1) B WHERE TMP....
2007-01-09 11:49:15
98
转载 SQL SERVER 快速重建所有视图
DECLARE test_cursor CURSORFOR select id,name from invest..sysobjects where OBJECTPROPERTY(id, N'IsView') = 1 and...
2006-12-30 10:22:59
783
转载 dos 命令执行SQL脚本的方法
ORACLE:sqlplus user/password@SID "d:test.sql"SQL SERVER:osql -S servername -U user -P password -i "d:test.sql"[@mo...
2006-12-21 08:49:57
307
转载 从后往前截取字符串
select substr('asdefeeffb',(instr('asdefeeffb','f',-1)-1)-length('asdefeeffb')) from dual[@more@] ...
2006-04-11 17:49:04
1295
转载 Oracle Date Function 讲解和事例
Oracle Date Function 讲解和事例请大家记住 1 year=1*12 months1 day=24 hours=24*(1*60mins)=24*60*(1*60 seconds)1 week =7 days注...
2006-03-22 10:51:14
105
转载 关于归档失败后数据库当机的处理方法
log_archive_dest_1 = "location=E:oracleoradatamisarchive reopen=2"[@more@] ...
2006-02-06 10:22:17
119
转载 ORA-12545 连接因对象主机或对象不存在而失败 的处理办法
SMSDB =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.190.9.241)(PORT = 1521)))(CONNECT_DATA =...
2006-02-06 10:18:41
151
转载 dos命令中的FOR循环
DOS 下的FOR循环 2003-06-21 阅读: 4400 for /L %%A in(1,1,254) do ping 192.168.1.%%A |find "Reply" >>ip.txt...
2005-04-25 21:48:30
235
转载 DOS命令大全
FTP命令使用大全FTP命令是Internet用户使用最频繁的命令之一，不论是在DOS还是UNIX操 作系统下使用FTP，都会遇到大量的FTP内部命令。 熟悉并灵活应用FTP的内部 命令，可以大大方便使用者，并收到事半功倍之效。...
2005-03-31 11:53:58
206
转载 格式化DOS日期(引用)
bat-任意截断替换字符 FOR /F ["options"] %variable IN (file-set) DO command [command-parameters]FOR /F ["options"] %variab...
2005-03-31 11:44:04
210
转载 ora-06413原因之所在
Here u go Error: ORA 6413 Text: Connection not open.------------------------------------------------------------Ca...
2005-03-31 08:48:41
247
转载 oracel命令速查
第一章：日志管理 1.forcing log switches sql> alter system switch logfile; 2.forcing checkpoints sql> alter system c...
2005-03-09 18:05:06
145
转载 sql server中建立到oracle的链接server
select * from sysserverssp_addlinkedserver 'OrclDB', 'Oracle', 'MSDAORA', 'hbmis'sp_addlinkedsrvlogin 'OrclDB', fa...
2005-03-09 17:39:28
76
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人