What is the accepted practice?

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

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

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
>

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