Not Again!

  • Comments posted to this topic are about the item Not Again!

  • This was removed by the editor as SPAM

  • good question. reminded me some old thoughts 🙂

  • twin.devil (2/18/2015)


    good question. reminded me some old thoughts 🙂

  • Thank you for the post, good one. Memory recall, remembered doing this in SQL 2000 instance for one app_user.

    (actually it was not hard to find out the right choice - I knew it was not the permission denial on definition, never knew what that 9485 flag did so had to check on that, and the remaining one must have been correct...)

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

  • Could this be a reason for preferring Count(1) over Count(*) - which is otherwise not an easy decision.

    Edit: No indeed, I misread the question.

  • Surely this must be a bug?

  • ..

  • Very interesting question, thanks.

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

  • Learned somthing new for me today, thanx!

  • I learned to today that I can set permissions at the column level. Never even considered trying to do that before.

    I really liked the story that went with the question. Keep up the good storytelling!

  • Very interesting question

  • I got it right but I don't think Steve got the answer to his question.

    Steve asked the simplest request: how many users on the website?

    I would interpret that question to mean how many users are currently logged on to the website, which is most likely not the total number of ID's in the users table. It's probably a rare occasion, if ever, that all users are logged on at the same time.

    😉

  • Thanks for the question.



    Everything is awesome!

  • Good one, Memory recall.

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

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