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
>