SQL
jswxharry
这个作者很懒,什么都没留下…
展开
-
SQL 中的模糊一一匹配
Table test1:ID NAME VOLUMN ----------------------------------------------------------------------- --------------原创 2014-03-13 22:11:29 · 810 阅读 · 0 评论 -
get date list from data range in Oracle
select rownum -1 + to_date('15-MAY-2006', 'dd-mon-yyyy') afrom all_objectswhere rownum < to_date('15-NOV-2017', 'dd-mon-yyyy')- to_date('15-MAY-2006', 'dd-mon-yyyy')修正下, 上述 做法有缺陷 当时间相隔天数超出all原创 2014-04-01 11:28:59 · 598 阅读 · 0 评论 -
dbo.sp_WhoIsActive
from: https://devjef.wordpress.com/tag/sp_whoisactive/ the easy way out: sp_WhoIsActive by Adam Machanic (Blog | @AdamMachanic ).转载 2014-10-26 10:18:43 · 2122 阅读 · 0 评论 -
SQL Server 有用语句搜集
如何查看客户端的IP地址,机器名,MAC地址,登陆名等信息select s.session_id,s.login_time,s.host_name,p.loginame,s.program_name,c.client_net_address,c.client_tcp_port,p.net_address as client_mac_address, c.local_net_address,c.转载 2014-10-26 17:20:07 · 72 阅读 · 0 评论 -
如何查看加密过的SQL Server procedure
http://sqljunkieshare.com/2012/03/07/decrypting-encrypted-stored-procedures-views-functions-in-sql-server-20052008-r2/转载 2015-01-15 15:24:21 · 1229 阅读 · 0 评论 -
SQL Server 开启专用管理员连接 DAC Dedicated Administrator Connection
http://www.mssqltips.com/sqlservertip/1801/enable-sql-server-2008-dedicated-administrator-connection/转载 2015-01-15 14:44:06 · 820 阅读 · 0 评论