Committing Work
-
Comments posted to this topic are about the item Committing Work
-
This was removed by the editor as SPAM
-
Good question, thank you
...
-
Learned something new. Thanks Steve!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Koen Verbeeck (11/20/2015)
Learned something new. Thanks Steve!That's true
-
Thought this looked too simple, but I guess Steve likes to make it easy on a Friday...
-
I knew that WORK keyword is optional, but it seemed too easy,
thanks Steve.
-
I never heard of WORK before, so I learned something new today. That's always a good way to end the week. Thanks.
-
Of course the correct answer is it throws an error, because nobody has a table named 'MyTable'. And if they do, the 'test' column is a GUID. :hehe:
-
It actually should work with previous versions as well. Documentation for SQL Server 2000 includes it, but I couldn't test on anything older than 2008R2.
https://technet.microsoft.com/en-us/library/aa258231(v=sql.80).aspx
It's weird that this is so old yet so unknown.
-
Interesting that this doesn't work
BEGIN TRANSACTION;
UPDATE
MyTable
SET
test = 9;
COMMIT WORK2
GO
But this does
BEGIN TRANSACTION;
UPDATE
MyTable
SET
test = 9;
COMMIT TRANSACTION WORK2
GO
I got it right not knowing about WORK but assuming they were the same.
-
Xavon (11/20/2015)
Of course the correct answer is it throws an error, because nobody has a table named 'MyTable'. And if they do, the 'test' column is a GUID. :hehe:Ha, I have so many MyTable's that I'm constantly having to guess higher and higher numbers to add to the end.
-
Steve Jones - SSC Editor (11/20/2015)
Xavon (11/20/2015)
Of course the correct answer is it throws an error, because nobody has a table named 'MyTable'. And if they do, the 'test' column is a GUID. :hehe:Ha, I have so many MyTable's that I'm constantly having to guess higher and higher numbers to add to the end.
Heh - Have you heard of a scratch database that gets rebuilt every so often? Or Tempdb, perhaps?
-
Thank for this easy question foreseeing the week-end.
-
Ed Wagner (11/20/2015)
Heh - Have you heard of a scratch database that gets rebuilt every so often? Or Tempdb, perhaps?This is in my Sandbox database. Nothing there needs to stay, but I sometimes start testing something and it might live for a few days, so don't want tempdb.
I just start creating a Mytable99 and if it works, all good.
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply