first of all, i'm new to sql OR stored procedure.
while reading online examples, i notice that in some examples there is [begin] and [end] and in some there is nothing as below.
create procedure newprocedure
as
select * from table1
GO
with [begin] and [end]
create procedure newprocedure
as
BEGIN
select * from table1
END
GO
I wonder when we use [begin] and [end] and when we should not use them.