| Author |
What is the accepted practice?
|
|
| Frank Rizzo 2006-01-29, 8:23 pm |
| As a c# refugee, I was wondering what was the accepted practice in the
SQL world:
Scenario 1:
if (1 = 2) begin
...
end
Scenario 2:
if (1 = 2)
begin
...
end
Thanks
| |
| Andrew J. Kelly 2006-01-29, 8:23 pm |
| I don't know if there is an "Accepted" practice but I see it most often like
#2. Personally I prefer that as well since it is easier to read and debug.
--
Andrew J. Kelly SQL MVP
"Frank Rizzo" <nospam@nospam.com> wrote in message
news:uv9ua6RJGHA.3944@tk2msftngp13.phx.gbl...
> As a c# refugee, I was wondering what was the accepted practice in the SQL
> world:
>
> Scenario 1:
> if (1 = 2) begin
> ...
> end
>
> Scenario 2:
> if (1 = 2)
> begin
> ...
> end
>
> Thanks
| |
| Nigel Rivett 2006-01-29, 8:23 pm |
| I always go with
if 1=2
begin
....
end
else
begin
....
end
"Frank Rizzo" wrote:
> As a c# refugee, I was wondering what was the accepted practice in the
> SQL world:
>
> Scenario 1:
> if (1 = 2) begin
> ...
> end
>
> Scenario 2:
> if (1 = 2)
> begin
> ...
> end
>
> Thanks
>
| |
| Adam Machanic 2006-01-29, 8:23 pm |
| I'll third what Andrew and Nigel said, and add to that the importance of
indentation:
IF (1=2)
BEGIN
--Indenting makes this much easier to identify as something nested
END
ELSE
BEGIN
--Here, too...
END
--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Frank Rizzo" <nospam@nospam.com> wrote in message
news:uv9ua6RJGHA.3944@tk2msftngp13.phx.gbl...
> As a c# refugee, I was wondering what was the accepted practice in the SQL
> world:
>
> Scenario 1:
> if (1 = 2) begin
> ...
> end
>
> Scenario 2:
> if (1 = 2)
> begin
> ...
> end
>
> Thanks
|
|
|
|