Search Results - VBForums

Search:

Type: Posts; User: InvisibleDuncan

Page 1 of 13 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    10
    Views
    300

    Re: or !=

    Oops - double post!
  2. Replies
    10
    Views
    300

    Re: or !=

    Thanks, guys. I hadn't seen != in years, but came across a whole clutch of them in a set of stored procedures written by a 3rd party. I was just wondering if they knew something I didn't.

    I think...
  3. Replies
    10
    Views
    300

    [RESOLVED] or !=

    Quick question, folks: In SQL, is there any reason to prefer <> or != over the other, or is it simply personal preference? Is one standard and one non-standard?

    Annoyingly, they're very hard terms...
  4. Replies
    14
    Views
    1,100

    Re: IRS Telephone Scam

    It wasn't Russell Brand, was it?
  5. Re: Permissions to use SPs and UDFs that don't update data

    Thanks, Bill - I'll give that one some thought. Our databases are huge with hundreds of tables, procedures and functions, so it may not be practical - but it's better than anything I've come up with...
  6. Re: Permissions to use SPs and UDFs that don't update data

    Bill: I'm using 2008 R2. You may be right about the functions - I thought that was the case but I wasn't sure.

    DS: Loads of our SPs update data, so we can't grant execute permissions on...
  7. Permissions to use SPs and UDFs that don't update data

    For security reasons, we developers don't have access to our live databases. However, read-only access is temporarily granted when we need to investigate specific problems that are happening in live....
  8. Re: Pattern matching for ASCII characters only

    Ah, right - that would probably explain it. Thanks!
  9. Pattern matching for ASCII characters only

    I'm trying to write a function that strips out all non-ASCII characters in a field when I select it, but I'm having trouble with the pattern matching. I've tried this (using the collation statement...
  10. Re: [SERIOUS] Scotland - Backpack Trip [\SERIOUS]

    It very much depends on what kind of things you like to do. I'd agree with Dex about going to a ceilidh if you get the chance - they're always full of high energy. I'd also recommend going to a...
  11. Replies
    45
    Views
    1,074

    Re: UKers look here

    I'm intrigued by the popular assertion that UKIP are right-wing. If you look at their policies, they are actually firmly left-wing, wanting to renationalise several industries and increase the size...
  12. Replies
    134
    Views
    3,910

    Re: Frickin' Lasers for Eyes!

    I think you mean "the worst bit so far". Wait until you start seeing ghosts, or murders as they happen. I'm fairly sure that's what happens after every eye operation.
  13. Replies
    10
    Views
    428

    Re: Worst Thing Ever?

    EastEnders. :mad:
  14. Re: Biggest Impact - TV/Movie Tech that's doesn't exist

    Surely a Tardis would trump all of these? The ability to travel anywhere in time and space beats the ability to travel anywhere in space.

    I'd go back in time and take out a patent on a rectangle...
  15. Replies
    134
    Views
    3,910

    Re: Frickin' Lasers for Eyes!

    That's the bit that impressed me about this whole thing: they didn't try to pressure you into going for the more expensive procedure.

    If it all goes horribly wrong, do they give you a jar to bring...
  16. Replies
    0
    Views
    138

    Breakpoints in SSIS not being hit

    I've inherited an SSIS package which is really rather horrible. It is now falling over on a particular task, and I'm trying to put a berakpoint in the script to find out what's happening. However,...
  17. Re: Passing an encrypted password into SQL Server from VB.Net

    In all honesty, as a developer myself I'm fairly relaxed about developers being able to see the password. Unfortunately, one of our team has been using these credentials to make changes to a database...
  18. Passing an encrypted password into SQL Server from VB.Net

    We have a few VB.Net applications that connect to a SQL Server 2008 database using SQL Server authentication. Basically, we have a config file that contains an encrypted password, and our...
  19. Replies
    14
    Views
    731

    Re: All perspective I guess...

    Did that really come as news to you, though? It's something that I assumed everyone was aware of.

    Many, many countries don't use computerised systems at immigration control, particularly at...
  20. Replies
    28
    Views
    1,091

    Re: Too late for that...

    From this side of the pond, the biggest problem with US politics would seem to be the money involved. This in turn leads to political campaigning being unbelievably vicious (if TV dramas are to be...
  21. Re: Join versus Where Exists

    That's a little mean if it's always the same bunch of people who help you out.
  22. Re: Join versus Where Exists

    Hmmm - I'm not sure whether I've successfully rated your posts. I just get the message that "you must spread some reputation around before rating this post" or words to that effect. I got the same...
  23. Re: Join versus Where Exists

    Guys - thank you. The execution plan was fairly non-committal, probably because there's no actual data in the Agent table anymore (someone helpfully dropped and recreated it), but it did look as if...
  24. Re: Join versus Where Exists

    szlamany - Our coding standards say to never use SELECT *, so I tend to stick with that even if it doesn't matter.

    It's SQL 2008 R2, and it's to be used for a view that will only be used as part...
  25. [RESOLVED] Join versus Where Exists

    I want to get data out of a single table, restricted to where an ID field exists on another table. The ID may exist more than once on the second table, so doing a join would cause me to get duplicate...
  26. Replies
    30
    Views
    1,525

    Re: Redskins

    As someone who comes from Britain but not from England, I would disagree. There's a massive difference.
  27. Replies
    30
    Views
    1,525

    Re: Redskins

    I think you were invaded by the Scots once or twice. ;)

    There are some people who get offended for a living, generally on behalf of someone else who is utterly unconcerned by the issue. I think...
  28. Replies
    18
    Views
    895

    Re: dday10-1

    Was this you?
    110569
  29. Replies
    31
    Views
    1,382

    Re: Vocabulary test

    No thinking, just knowing.

    I got 3,860 on my second attempt, but it's not registering my clicks quickly. I had a couple where I clicked within the first second, but it sat and waited for a moment...
  30. Replies
    145
    Views
    7,284

    Re: Sorry guys but I'm done!

    I'll give Meals-On-Wheels a shout for you.
  31. Replies
    145
    Views
    7,284

    Re: Sorry guys but I'm done!

    I promoted you. ;)

    No, I actually come from the Western Highlands and I know a few McIlhinney families, so I assumed you were from a similar area.



    Fin? I'd have thought "Fitz".
  32. Replies
    3,224
    Views
    118,288

    Re: The Golden Chair

    I have debatable onions.
  33. Replies
    31
    Views
    1,382

    Re: Vocabulary test

    3,740 for my first attempt. Might try again later, but I'm supposed to be working.
  34. Replies
    145
    Views
    7,284

    Re: Sorry guys but I'm done!

    Funky was right - it should be JMcI. Just look at the jackets of Scottish football players and managers for examples. That said, if it doesn't bother JMcI, it shouldn't bother the rest of us.*

    As...
  35. Replies
    3,224
    Views
    118,288

    Re: The Golden Chair

    Your auntie's potato has just eaten my hat.
  36. Replies
    18
    Views
    3,482

    Re: Do you think Russia will free them?

    The problem is that the Greenpeace activists have spent too long living in the land of no consequence. In most of the western world they benefit from a very sympathetic press, mostly because they...
  37. Replies
    72
    Views
    4,676

    Re: Advantages of Smoking

    I would have to disagree with that. I started smoking at 13, and was smoking 20 a day from the age of about 16 until I gave up at 26. The first week was tough, but that was it - I've never craved one...
  38. Replies
    3,224
    Views
    118,288

    Re: The Golden Chair

    I want you to butter my otter.
  39. VS 2010 Re: What's the best way to return data from a WCF data service?

    I've never even heard of JSON, which is a little worrying. Time for some research, I reckon.

    Thanks, guys - I'm sure I'll be back with more questions fairly soon...
  40. Replies
    127
    Views
    7,256

    Re: Here we go again

    Bizarrely, it was actually Germany turning on Russia that made the difference. If they had kept to their non-aggression pact, they would have been able to commit all their forces towards us. As...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.