Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Checking sp standards in TSQl

4 posts in Product Futures Discussion Last posting was on 2004-10-22 11:24:34.0Z
Eugene Korolkov Posted on 2004-10-20 18:40:40.0Z
Message-ID: <4176AF1D.895F59B1@davidsohn.com>
From: Eugene Korolkov <ekorolkov@davidsohn.com>
X-Mailer: Mozilla 4.77 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Checking sp standards in TSQl
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 12.3.91.165
X-Original-NNTP-Posting-Host: 12.3.91.165
Date: 20 Oct 2004 11:40:40 -0700
X-Trace: forums-1-dub 1098297640 12.3.91.165 (20 Oct 2004 11:40:40 -0700)
X-Original-Trace: 20 Oct 2004 11:40:40 -0700, 12.3.91.165
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1635
Article PK: 96631

Hi,

I think it would be good to incorporate standards checking in
in TSQL compilation error processing , so that sp would be rejected to create if
it does not support at least below standards:
1. header
2. return code
3. transaction processing
4. error processing
5. comments
6. intervals (2,4,6)
7. beautification
8. version control
9. debug switches

Regards,
Eugene


Jeff Tallman Posted on 2004-10-21 15:45:03.0Z
From: Jeff Tallman <tallman@sybase.com>
User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Checking sp standards in TSQl
References: <4176AF1D.895F59B1@davidsohn.com>
In-Reply-To: <4176AF1D.895F59B1@davidsohn.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpn-concord-047.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-047.sybase.com
Message-ID: <4177d97f@forums-1-dub>
Date: 21 Oct 2004 08:45:03 -0700
X-Trace: forums-1-dub 1098373503 158.159.8.47 (21 Oct 2004 08:45:03 -0700)
X-Original-Trace: 21 Oct 2004 08:45:03 -0700, vpn-concord-047.sybase.com
Lines: 24
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1640
Article PK: 96636

What do you mean by intervals (2,4,6)????

Eugene Korolkov wrote:

> Hi,
>
> I think it would be good to incorporate standards checking in
> in TSQL compilation error processing , so that sp would be rejected to create if
> it does not support at least below standards:
> 1. header
> 2. return code
> 3. transaction processing
> 4. error processing
> 5. comments
> 6. intervals (2,4,6)
> 7. beautification
> 8. version control
> 9. debug switches
>
> Regards,
> Eugene
>
>


Carl Kayser Posted on 2004-10-22 11:24:34.0Z
From: "Carl Kayser" <kayser_c@bls.gov>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <4176AF1D.895F59B1@davidsohn.com> <4177d97f@forums-1-dub>
Subject: Re: Checking sp standards in TSQl
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: 146.142.33.192
Message-ID: <4178edee$1@forums-2-dub>
X-Original-Trace: 22 Oct 2004 04:24:30 -0700, 146.142.33.192
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Oct 2004 04:24:31 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Oct 2004 04:24:34 -0700
X-Trace: forums-1-dub 1098444274 10.22.108.75 (22 Oct 2004 04:24:34 -0700)
X-Original-Trace: 22 Oct 2004 04:24:34 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1643
Article PK: 96639

I suspect that he means indentation intervals of a specified number of
spaces. Whether it is

if (...)
begin
(bunch of stuff)
end

or

if (...)
begin
(bunch of stuff)
end

or some other convention is ambiguous.

"Jeff Tallman" <tallman@sybase.com> wrote in message
news:4177d97f@forums-1-dub...
>
> What do you mean by intervals (2,4,6)????
>
> Eugene Korolkov wrote:
>
> > Hi,
> >
> > I think it would be good to incorporate standards checking in
> > in TSQL compilation error processing , so that sp would be rejected to
create if
> > it does not support at least below standards:
> > 1. header
> > 2. return code
> > 3. transaction processing
> > 4. error processing
> > 5. comments
> > 6. intervals (2,4,6)
> > 7. beautification
> > 8. version control
> > 9. debug switches
> >
> > Regards,
> > Eugene
> >
> >


Eugene Korolkov Posted on 2004-10-21 18:21:09.0Z
Message-ID: <4177FC00.4CADA82A@davidsohn.com>
From: Eugene Korolkov <ekorolkov@davidsohn.com>
X-Mailer: Mozilla 4.77 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
To: Jeff Tallman <tallman@sybase.com>
Subject: Re: Checking sp standards in TSQl
References: <4176AF1D.895F59B1@davidsohn.com> <4177d97f@forums-1-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: 12.3.91.165
X-Original-Trace: 21 Oct 2004 11:21:02 -0700, 12.3.91.165
Lines: 34
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 21 Oct 2004 11:21:08 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 21 Oct 2004 11:21:09 -0700
X-Trace: forums-1-dub 1098382869 10.22.108.75 (21 Oct 2004 11:21:09 -0700)
X-Original-Trace: 21 Oct 2004 11:21:09 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1642
Article PK: 96641

Sorry, it suppose to be indents (2 spaces, 4 spaces, 6 spaces) like below:
IF ...THEN
----BEGIN
ELSE ...
----BEGIN

Eugene

Jeff Tallman wrote:

> What do you mean by intervals (2,4,6)????
>
> Eugene Korolkov wrote:
>
> > Hi,
> >
> > I think it would be good to incorporate standards checking in
> > in TSQL compilation error processing , so that sp would be rejected to create if
> > it does not support at least below standards:
> > 1. header
> > 2. return code
> > 3. transaction processing
> > 4. error processing
> > 5. comments
> > 6. intervals (2,4,6)
> > 7. beautification
> > 8. version control
> > 9. debug switches
> >
> > Regards,
> > Eugene
> >
> >