« first day (1383 days earlier)      last day (3489 days later) » 

Aaron Bertrand
Aaron Bertrand
3:01 AM
> However, I remembered that if a stored procedure doesn't have any parameters, you can call it without exec.
Oh boy. "I remembered something I totally made up!"
1
Q: Weird behavior of Try-Catch in a Stored Procedure

Jesan FafonI have a stored procedure where I need to cast to a type, but do not know if the cast will succeed. In an imperative language, I would use some sort of TryCast pattern. I figured that this would be equivalent in T-SQL: begin try select cast(@someValue as SomeType) end try begin catch end catc...

sql-server tsql stored-procedures transactions try-catch
@ypercube yes IIRC DELETE FROM A FROM t AS A is legal syntax, but why you would write it that way I have no idea. The first FROM is unnecessary noise and doesn't help clarify or self-document what's going on IMHO.
 
 
16 hours later…
ypercube
ypercube
6:58 PM
@AAron, sorry I barged onto your answer but that supercat guy annoyed me with his comments all over that question.
 
 
4 hours later…
ypercube
ypercube
10:29 PM
All the nonsense comments. I wish we could downvote comments sometimes.
 

« first day (1383 days earlier)      last day (3489 days later) »