DONEPROC

Question

Post reply

DONEPROC

ksatpute123

Hall of Fame

Points: 3325
More actions
October 21, 2014 at 10:42 pm

#294404

Comments posted to this topic are about the item DONEPROC

Viewing 15 posts - 1 through 15 (of 24 total)

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

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 1

Never heard of it. Probably will never use it. Misread the documentation and got it wrong.

Nice question though 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

F. van Ruyven SSCommitted Points: 1507 More actions · Answer 2

Never heard of it, so I googled. Found this: http://msdn.microsoft.com/en-us/library/dd340753.aspx

There it says 'CurCmd', not 'CurrCmd'. Apart from that all 5 seem to be correct.

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 3

F. van Ruyven (10/22/2014)
There it says 'CurCmd', not 'CurrCmd'. Apart from that all 5 seem to be correct.

The question said:

A DONEPROC token is sent for each SQL statements within a stored procedure that has been executed.

The documentation says:

A DONEPROC token is sent when all the SQL statements within a stored procedure have been executed.

This was the part that I misread. 🙂

Statement number 5 is also incorrect, the data types are not the same.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Same here, never heard about it b4 & I don`t think I will use it in the future, so had 2 do some R&D on it.

Thanx 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Rune Bivrin SSCrazy Eights Points: 8597 More actions · Answer 5

Quite frankly: If you think you have to know this, you're very likely doing something wrong. Still, I've earned yet another very arcane bragging point.:hehe:

Just because you're right doesn't mean everybody else is wrong.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 6

Thank you for the post, really eye opening.. And really had no idea what this was.

I read it and without any research, i selected the choice and got it wrong. Just out of curiousity, how where and when we are suppose to use this? Any example available?:-)

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

Rune Bivrin SSCrazy Eights Points: 8597 More actions · Answer 7

Well, if you don't like any of the available clients API:s, or if you're implementing SQL Server support on a new platform, you're going to have to know this very well. Otherwise, not so much...

Just because you're right doesn't mean everybody else is wrong.

ksatpute123 Hall of Fame Points: 3325 More actions · Answer 8

Raghavendra Mudugal (10/22/2014)
Thank you for the post, really eye opening.. And really had no idea what this was.
I read it and without any research, i selected the choice and got it wrong. Just out of curiousity, how where and when we are suppose to use this? Any example available?:-)

I have already included a use case in the form of api request in the answer:

http://pekim.github.io/tedious/api-request.html

I hope the following link can shed more light on use on use of tokens in packet data streams.

http://msdn.microsoft.com/en-us/library/dd341450.aspx

Toni-256719 SSCertifiable Points: 5997 More actions · Answer 9

There is a typo in option #4 that caused me to get it wrong.

4) The Token Stream Definition parameters are TokenType, Status, CurrCmd, DoneRowCount

I thought the CurrCmd parameter typo was intentional so I didn't select this option.

For the QotD, it's always so hard to tell.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 10

ksatpute123 (10/22/2014)
Raghavendra Mudugal (10/22/2014)
Thank you for the post, really eye opening.. And really had no idea what this was.
I read it and without any research, i selected the choice and got it wrong. Just out of curiousity, how where and when we are suppose to use this? Any example available?:-)
I have already included a use case in the form of api request in the answer:
http://pekim.github.io/tedious/api-request.html
I hope the following link can shed more light on use on use of tokens in packet data streams.
http://msdn.microsoft.com/en-us/library/dd341450.aspx

Thanks for the link, actually i saw the use case, but still i dont clearly understand its purpose. Say, NOLOCK, i can understand it usafe and its purpose and its pros and cons.. It kind of give you the clarity, but i am faiiling this to see. I will keep this in mind, in parallel will dig deeper.

Thank you.

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

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 11

Raghavendra Mudugal (10/22/2014)
ksatpute123 (10/22/2014)
Raghavendra Mudugal (10/22/2014)
Thank you for the post, really eye opening.. And really had no idea what this was.
I read it and without any research, i selected the choice and got it wrong. Just out of curiousity, how where and when we are suppose to use this? Any example available?:-)
I have already included a use case in the form of api request in the answer:
http://pekim.github.io/tedious/api-request.html
I hope the following link can shed more light on use on use of tokens in packet data streams.
http://msdn.microsoft.com/en-us/library/dd341450.aspx
Thanks for the link, actually i saw the use case, but still i dont clearly understand its purpose.

Apparently it is some sort of NodeJS API on top of SQL Server. Whatever that means 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

I had never heard of it either. Read the MSDN page, so I learned something. Like other who have posted here, I'll probably never use it.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 13

New to me too but sounds interesting. I think I'll look into it more. Thanks.

OCTom SSChampion Points: 11785 More actions · Answer 14

ksatpute123 (10/22/2014)
Raghavendra Mudugal (10/22/2014)
Thank you for the post, really eye opening.. And really had no idea what this was.
I read it and without any research, i selected the choice and got it wrong. Just out of curiousity, how where and when we are suppose to use this? Any example available?:-)
I have already included a use case in the form of api request in the answer:
http://pekim.github.io/tedious/api-request.html
I hope the following link can shed more light on use on use of tokens in packet data streams.
http://msdn.microsoft.com/en-us/library/dd341450.aspx

That use case does not describe its use. It shows code but does not describe what it is doing. Either that or I just don't understand what it is saying. Besides the link looks like it's for a product called Tedious that has something to do with the TDS protocol which is beyond my understanding.

Thanks for the question, though, as I got exposed to something completely outside of my day-to-day experience which is a good thing.

Tom