October 22, 2014 at 12:29 am
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
October 22, 2014 at 12:47 am
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.
October 22, 2014 at 12:54 am
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
October 22, 2014 at 1:45 am
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
October 22, 2014 at 2:30 am
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:
October 22, 2014 at 2:35 am
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.
October 22, 2014 at 2:49 am
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...
October 22, 2014 at 2:50 am
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.
October 22, 2014 at 3:29 am
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.
October 22, 2014 at 3:40 am
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.
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.
October 22, 2014 at 3:45 am
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.
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
October 22, 2014 at 5:38 am
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.
October 22, 2014 at 6:57 am
New to me too but sounds interesting. I think I'll look into it more. Thanks.
October 22, 2014 at 6:57 am
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.
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
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply