From: Pavel Stehule <pavel.stehule@gmail.com>
To: Richard Broersma Jr <rabroersma@yahoo.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Cc: liuzg2@21cn.com
Subject: Re: how to use pgsql like mssql
Date: Thu, 27 Dec 2007 05:54:03 +0100
Message-ID: <162867790712262054l19481519icf55948220399598@mail.gmail.com> (raw)
In-Reply-To: <536502.37602.qm@web31812.mail.mud.yahoo.com>
References: <30781358.9441198721119056.JavaMail.root@webmail5>
<536502.37602.qm@web31812.mail.mud.yahoo.com>
On 27/12/2007, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> --- On Wed, 12/26/07, liuzg2@21cn.com <liuzg2@21cn.com> wrote:
>
> > but i do not want use function or procedure
>
>
> Are you sure? I thought that:
>
> DECLARE
> IF --control structures
> @@rowcount
>
> where only usable in a store procedure. Am I incorrect, or are these keywords accessible from the SQL prompt?
>
You can use outside procedure in T-SQL.
Pavel
> Regards,
> Richard Broersma Jr.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pavel.stehule@gmail.com, rabroersma@yahoo.com, liuzg2@21cn.com
Subject: Re: how to use pgsql like mssql
In-Reply-To: <162867790712262054l19481519icf55948220399598@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox