Re: Graphical Oracle administration
From: Tony Rogerson <tonyrogerson_at_torver.net>
Date: Sun, 25 May 2008 09:46:46 +0100
Message-ID: <g1b95r$4ou$1$8300dec7@news.demon.co.uk>
Date: Sun, 25 May 2008 09:46:46 +0100
Message-ID: <g1b95r$4ou$1$8300dec7@news.demon.co.uk>
> http://www.psoug.org/reference/sqlserver.html
Be VERY VERY careful as a lot of the information on that link is both wrong and biased 100% towards Oracle.
I've tasked Denial Again with correcting it but he just won't.
One of the many errors is his storage concepts; it's all wrong.
A database has one (the primary) or many file groups; these file groups can have 1 or many physical files, we place objects on file groups and not files.
Another one is the IN and OUT parameters where he states we only have IN and OUT parameters - below is an example of IN-OUT....
Create proc x
@parm int output
as
set @parm = @parm * 10
go
declare @inout int
set @inout = 10
exec x @parm = @inout OUTPUT
print @inout
-- Tony Rogerson, SQL Server MVP http://sqlblogcasts.com/blogs/tonyrogerson [Ramblings from the field from a SQL consultant] http://sqlserverfaq.com [UK SQL User Community]Received on Sun May 25 2008 - 03:46:46 CDT