|
|
-
jerik1 Commented 5 Months ago through Ask
Well exactly as you're saying. To me it seems like just RETURN is not executed, or is not considered as statement. But I didn't find anything about it in BOL or other documentation. That's why I'm asking.
Ok, let it be. Many thanks....
|
-
jerik1 Commented 5 Months ago through Ask
Thanks, but you didn't get the point: I'm working with @@ERROR variable right after statement, but the behavior differs whether the statement that invokes error ends with RETURN statement or RETURN statement with assigned number....
|
-
jerik1 Posted 5 Months ago through Ask
Does anybody have an idea why this is happening:@@ERROR variable is = 0 when the RAISERROR statement in calling procedure is followed by RETURN statement with assigned number OR when NOT followed by RETURN statement at all when error is invoked in CATCH...
|
-
jerik1 Commented 10 Months ago through Blogs
We're using this method:
(CONVERT(DATETIME,CONVERT(INT,CONVERT(FLOAT,@Date))))...
|
-
jerik1 Commented 12 Months ago through Blogs
Didn't understand the "fun with.." much. To me it's made to be the same.
Here is what I mean saying that position after ON clause doesn't matter:
-- populate data
USE tempdb;
CREATE TABLE L(
ID INT IDENTITY(1,1) NOT NULL
,V...
|
-
jerik1 Liked 12 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
jerik1 Commented 12 Months ago through Blogs
Don't agree with the explanation of what left and right exactly means. According to my observations, LEFT table is always the one mentioned after the FROM clause, RIGHT one is after the JOIN. The position after ON clause doesn't matter....
|