Comments
Sort by recent activity
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