SQL SERVER / ORACLE / SYBASE
文章平均质量分 82
ayongwust_csts
这个作者很懒,什么都没留下…
展开
-
INF: SQL Server Procedure to Change Object Owner come from: http://support.microsoft.com/kb/275312
If you have numerous objects that require an ownership change, you can use the following SQL Server stored procedure to ease the process: if exists (select * from sysobjects where id = object_id(N[原创 2008-04-10 21:21:00 · 410 阅读 · 0 评论 -
Get the list of permissions of database object
Get the list of permissions of database object By Deepthi Viswanathan Nair, 2007/09/28 sp_helprotect is the system stored procedure used to determine the user level permissions of database obj转载 2008-04-24 13:49:00 · 285 阅读 · 0 评论 -
SQL2005中利用xml拆分字符串序列
效率不一定很高,但是肯定比替换为select union all好些,起码不用考虑因为字符串过长而导致动态sql语句过长代码如下:DECLARE @str varchar(1000)DECLARE @idoc int;DECLARE @doc xml; set @str=1¦3¦4¦25set @doc=cast(+replace(@str,¦,)+ as xml)原创 2008-05-24 22:43:00 · 314 阅读 · 0 评论 -
Transactions in Sybase
if exists (select 1 from sysobjects where id = object_id(tA2) and type = U) drop table tA2gobegin transaction tA2LOCK TABLE tA2 IN SHARE MODEcommit transa原创 2009-01-09 18:18:00 · 664 阅读 · 0 评论 -
Bind variables - The key to application performance | comes from: http://www.akadia.com/services/ora_bind_variables.html
If youve been developing applications on Oracle for a while, youve no doubt come across the concept of «Bind Variables». Bind variables are one of those Oracle concepts that experts freque转载 2009-01-20 11:02:00 · 553 阅读 · 0 评论 -
sql server 数据脚本生成工具
使用: SqlDataToScript 吧. 可对SQL SERVER2000数据库中的某个表中的特定(或全部)记录生成SQL脚本,在适当的时候进行还原。用于小数据量情况下的数据备份或制作数据库更新脚本。运行环境: Windows 2000/Windows XP/Win2003 + .net框架1.1版 + MDAC2.6及以上版本 + Sql Server 2000原创 2009-02-28 10:58:00 · 390 阅读 · 0 评论 -
Oracle 中的左连和右连
An Oracle SQL outer join differs from a natural join because it includes non-matching rows. Oracle SQL has several joins syntax variations for outer joins.Outer join (+) syntax examplesThe most c原创 2009-03-12 10:42:00 · 564 阅读 · 0 评论 -
如何在Oracle中重载存储过程 Overloading Procedures in PL/SQL http://it.toolbox.com/blogs/oracle-guide/overloading-procedures-in-plsql-1439
An Experts Guide to Oracle Technology by LewisC (Senior Datawarehouse and BI Consultant) Lewis Cunningham is an Oracle ACE, Database Architect and self-professed database geek. Lewis转载 2009-03-27 11:07:00 · 1042 阅读 · 0 评论 -
Robert Vollman 's blog
http://rpc.blogrolling.com/redirect.php?r=48e3686981be65d6ead4f27013a58a07&url=http%3A%2F%2Fthinkoracle.blogspot.com%2F I love data. Collecting, storing, manipulating, studying and using data. Or原创 2009-03-27 11:22:00 · 421 阅读 · 0 评论