Implicit transaction mode

Question

Implicit transaction mode

Viewing 12 posts - 16 through 26 (of 26 total)

You must be logged in to reply to this topic. Login to reply

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 1

Cliff Jones (8/12/2014)

Raghavendra Mudugal (8/12/2014)
TomThomson (8/12/2014)
Stewart "Arturius" Campbell (8/12/2014)
Good question, thanks Hugo
....
hmm "Hugo"?
Yes, today's email stated that it was Hugo's question for some reason.

subject of the email is "Data Mining: Part 13 PowerShell (SQLServer?Central 8/12/2014)"?

if yes.... I see no reference of mentioning the sql master. it has the same author's name of this post.

strange.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Hugo Kornelis SSC Guru Points: 64780 More actions · Answer 2

It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented with the author of the previous day.

As the well-known sasying geos, "there are two hard things in computer science: cache invalidation, naming things, and off-by-one errors".

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Cliff Jones SSChampion Points: 10547 More actions · Answer 3

Raghavendra Mudugal (8/12/2014)

Cliff Jones (8/12/2014)
Raghavendra Mudugal (8/12/2014)
TomThomson (8/12/2014)
Stewart "Arturius" Campbell (8/12/2014)
Good question, thanks Hugo
....
hmm "Hugo"?
Yes, today's email stated that it was Hugo's question for some reason.
subject of the email is "Data Mining: Part 13 PowerShell (SQLServer?Central 8/12/2014)"?
if yes.... I see no reference of mentioning the sql master. it has the same author's name of this post.
strange.

You are correct. It references yesterday's QOTD as being Hugo's but it was not.

Cliff Jones SSChampion Points: 10547 More actions · Answer 4

Hugo Kornelis (8/12/2014)
It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented with the author of the previous day.
As the well-known sasying geos, "there are two hard things in computer science: cache invalidation, naming things, and off-by-one errors".

When in doubt, thank Hugo.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 5

Cliff Jones (8/12/2014)
Hugo Kornelis (8/12/2014)
It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented with the author of the previous day.
As the well-known sasying geos, "there are two hard things in computer science: cache invalidation, naming things, and off-by-one errors".
When in doubt, thank Hugo.

+1, as always. It is great to see the master's comment.:-)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

jramirezgt Newbie Points: 7 More actions · Answer 6

SQL first parse the SQL statement and found that is a sintaxis error becouse there are two parameter in the values section and the table have only one field.

INSERT INTO tempTable (id) VALUES (1), (2)

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 7

Raghavendra Mudugal (8/12/2014)
Cliff Jones (8/12/2014)
Hugo Kornelis (8/12/2014)
It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented with the author of the previous day.
As the well-known sasying geos, "there are two hard things in computer science: cache invalidation, naming things, and off-by-one errors".
When in doubt, thank Hugo.
+1, as always. It is great to see the master's comment.:-)

+1

Thanks

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 8

jramirezgt (8/12/2014)
SQL first parse the SQL statement and found that is a sintaxis error becouse there are two parameter in the values section and the table have only one field.
INSERT INTO tempTable (id) VALUES (1), (2)

You can insert multiple rows with single INSERT statement. Please refer: http://msdn.microsoft.com/en-IN/library/ms174335.aspx -- take a look: B. Inserting multiple rows of data

Thanks

Hany Helmy SSChampion Points: 13921 More actions · Answer 9

Iulian -207023 (8/12/2014)
OK I got it, so the key is in SET IMPLICIT_TRANSACTIONS ON ... interesting. Thank you for the question.

+ 1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

Easy 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Hugo Kornelis (8/12/2014)
It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented with the author of the previous day.
As the well-known sasying geos, "there are two hard things in computer science: cache invalidation, naming things, and off-by-one errors".

That's hopelessly optimistic.

You should say "there are four hard things in computer science: cache invalidation, naming things, and off-by-one errors".

Tom

Ken SSCoach Points: 17191 More actions · Answer 12

TomThomson (8/13/2014)
Hugo Kornelis (8/12/2014)
It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented with the author of the previous day.
As the well-known sasying geos, "there are two hard things in computer science: cache invalidation, naming things, and off-by-one errors".
That's hopelessly optimistic.
You should say "there are four hard things in computer science: cache invalidation, naming things, and off-by-one errors".

🙂