Activity overview
Latest activity by JustinBird
+1 here / comments
+1 here
Current statement execution! This one is super cool. Supposing you have a long code block with multiple separate statements in it, if you want to run a single block of code you have to highlight that block of code and hit execute / F5. You can do the same thing just by hitting SHIFT + F5. I've not been able to use prompt in recent assignments but current client uses Redgate so some things I'd long forgotten are coming back to me and that one just came to me today! / comments
Current statement execution! This one is super cool. Supposing you have a long code block with multiple separate statements in it, if you want to run a single block of code you have to highlight th...
There's another side to this - people have their own preferences for reading styles, so some devs might have their own style whilst they're coding and then simply "team format" it to be pushed to source control. Everybody wins! / comments
There's another side to this - people have their own preferences for reading styles, so some devs might have their own style whilst they're coding and then simply "team format" it to be pushed to s...
Well I'll kick things off! For me it's being able to consistently format code before checking in to source control by sharing formatting settings across the team. We keep ours alongside the code in source control so everyone can keep up to date. Adhering to code formats ensures "developer preference" doesn't result in false changes in the code base where a developer alters a block of code just to lay it out differently. The hardest part is getting the team to decide on a format! / comments
Well I'll kick things off! For me it's being able to consistently format code before checking in to source control by sharing formatting settings across the team. We keep ours alongside the code in...
The point of the error is that your procedure in its entirety isn't encapsulated in a BEGIN/END block, not the entire statement. What it is looking for you to do is this; CREATE OR ALTER PROCEDURE #ST003_EXAMPLE AS
BEGIN
BEGIN
PRINT 'Great';
END;
-- some debug after END...
THROW 50000, 'Really!', 1;
END;
GO -- Separated statement for easy executing whole window from SSMS
EXECUTE #ST003_EXAMPLE;
/ comments
The point of the error is that your procedure in its entirety isn't encapsulated in a BEGIN/END block, not the entire statement. What it is looking for you to do is this;CREATE OR ALTER PROCEDURE #...