Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #135

Re: Stored Procedure Code Critique Requested

From Erland Sommarskog <esquel@sommarskog.se>
Newsgroups comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject Re: Stored Procedure Code Critique Requested
Followup-To comp.databases.ms-sqlserver
Date 2011-04-07 00:05 +0200
Organization Erland Sommarskog
Message-ID <Xns9EC0FA56E7CYazorman@127.0.0.1> (permalink)
References <nk1np6tl9rthkh068vji35fpq34p7v21ff@4ax.com> <4d9cbbf9$0$81475$e4fe514c@news.xs4all.nl> <cbopp6906av1jifao8qg1ke4usajmf3fgc@4ax.com>

Cross-posted to 2 groups.

Followups directed to: comp.databases.ms-sqlserver

Show all headers | View raw

Gene Wirchenko (genew@ocis.net) writes:
>      I do not like the clutter.  To guard against the risk you imply
> (and it is a valid concern), instead, I am VERY fussy with indentation
> as in, in C:


My personal standard is that I don't have BEGIN END, if it is a single
line, but if there are more than one line, I have BEGIN END, even if
it's a single statement.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Stored Procedure Code Critique Requested Gene Wirchenko <genew@ocis.net> - 2011-04-05 14:26 -0700
  Re: Stored Procedure Code Critique Requested Erland Sommarskog <esquel@sommarskog.se> - 2011-04-06 07:43 +0000
    Re: Stored Procedure Code Critique Requested Gene Wirchenko <genew@ocis.net> - 2011-04-06 11:43 -0700
      Re: Stored Procedure Code Critique Requested Erland Sommarskog <esquel@sommarskog.se> - 2011-04-06 23:58 +0200
  Re: Stored Procedure Code Critique Requested Henk van den Berg <hvandenberg@xs4all.nl> - 2011-04-06 21:15 +0200
    Re: Stored Procedure Code Critique Requested Gene Wirchenko <genew@ocis.net> - 2011-04-06 14:59 -0700
      Re: Stored Procedure Code Critique Requested Erland Sommarskog <esquel@sommarskog.se> - 2011-04-07 00:05 +0200
  Re: Stored Procedure Code Critique Requested Philipp Post <post.philipp@googlemail.com> - 2011-04-12 06:14 -0700

csiph-web