Comments
Sort by recent activity
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...
I've failed to make any of these this year [image] home office burnout is real. Hope you all have a great holiday period whatever you get up to. See you all in 2021! / comments
I've failed to make any of these this year home office burnout is real. Hope you all have a great holiday period whatever you get up to. See you all in 2021!
Done! / comments
Done!
I was on the road at 4 pm yesterday so couldn't attend, looking forward to watching this! / comments
I was on the road at 4 pm yesterday so couldn't attend, looking forward to watching this!
+1 here / comments
+1 here
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 #...
Thanks @bob_walker! / comments
Thanks @bob_walker!
Honoured to become a FoRG [image] hello fellow FoRGs! Pluralsight subs is great news @RoseannaW! / comments
Honoured to become a FoRG hello fellow FoRGs! Pluralsight subs is great news @RoseannaW!
Dave60103 said:
I've been writing for SQLServerCentral fora long time but have never spoken at an event. Although it is out of my comfort zone I should like to try it but don't know where or how to start. The only presentations I have given have been internal presentations.
I'd not done a talk until last year, took the leap doing a lightning talk at a local user group on SQL Provision funnily enough. It seems such a daunting thing, but having done it once and getting a good response it certainly helps build the confidence. I'm sure there's plenty of decent user groups around your way you could take a look into and just turn one of your SSC blogs into a talk (which is what I did incidentally). / comments
Dave60103 said:
I've been writing for SQLServerCentral fora long time but have never spoken at an event. Although it is out of my comfort zone I should like to try it but don't know where or...
This is super cool [image] / comments
This is super cool