Forum Replies Created

Viewing 15 posts - 3,241 through 3,255 (of 15,381 total)

  • RE: SQL Injection, Still?

    GoofyGuy (2/17/2015)

    I am in full agreement of porters and stouts though. The darker the beer the better for me.

    Aye, it's best when carved with a fork and knife!

    It...

    February 17, 2015 at 3:21 pm

    #1778206

  • RE: SQL Injection, Still?

    GoofyGuy (2/17/2015)

    Almost unbelievably it is unfair to talk of American craft beers like that nowadays. I had a terrific American IPA just last week.

    Gaz, it was indeed an unexpected...

    February 17, 2015 at 2:57 pm

    #1778200

  • RE: SQL Injection, Still?

    GoofyGuy (2/17/2015)

    Pardon me if I get slightly defensive that in one breath you say we can't code or make beer.

    Pardon me if my joking didn't come across as such.

    Let's go...

    February 17, 2015 at 1:56 pm

    #1778190

  • RE: SQL Injection, Still?

    GoofyGuy (2/17/2015)

    But you didn't refrain.

    * Sigh *

    The Yanks still don't do irony. 😉

    If you assume that all beers brewed in America are as crappy as the ones you get...

    February 17, 2015 at 1:50 pm

    #1778186

  • RE: SQL Injection, Still?

    GoofyGuy (2/17/2015)

    IT these days looks more like a craft brewery where we keep changing the recipe: sometimes it works, and sometimes it's disgusting.

    I'm tempted to make a comparison between American...

    February 17, 2015 at 12:57 pm

    #1778163

  • RE: Query running slow one row at a time after intial pull

    mittensonmaui (2/17/2015)

    Hi all, I am writing a query that hits a table with 1.5 billion rows. After about a minute I get back about 28k of 60k then the query...

    February 17, 2015 at 9:41 am

    #1778102

  • RE: I have a field that has data like this and I need to pull out what is between the "-" and "x" 5.625X11.25-2.875x8.5 would be 2.875

    Or if your data is consistent in the formatting you can do this with some string manipulation.

    Using Lowell's excellent setup (thanks):

    ;WITH MyCTE([jmaPartShortDescription])

    AS

    (

    SELECT '5.625X11.25-2.875x8.5 ' UNION ALL

    SELECT '5.625X35.25-2.875x32.5 ' UNION ALL

    SELECT...

    February 17, 2015 at 9:37 am

    #1778101

  • RE: SQL Injection, Still?

    Venkat.Mantraratnam (2/17/2015)

    I need some help rewriting the stored procedure shown below to avoid sql injection. Also Web application currently replaces single quotes with 2 single quotes for @SearchString parameter and...

    February 17, 2015 at 8:33 am

    #1778081

  • RE: Approximate Data types

    TomThomson (2/16/2015)

    Sean Lange (2/16/2015)

    TomThomson (2/16/2015)

    I am really surprised that so many people got this wrong. Obviously this is a topic which needs some more attention if this many people are...

    February 16, 2015 at 2:51 pm

    #1777911

  • RE: Approximate Data types

    TomThomson (2/16/2015)

    Sean Lange (2/16/2015)

    Great back to basics question. I am shocked at the response rate.

    Correct answers: 57% (166)

    Incorrect answers: 43% (123)

    Total attempts: 289

    I am really surprised that so many people...

    February 16, 2015 at 11:58 am

    #1777893

  • RE: Wild Card search

    SQLAssAS (2/16/2015)

    I know how to do a drop down, but want to know how to do a wildcard search too 😉

    https://msdn.microsoft.com/en-us/library/ms179859.aspx

    As I said before you are going to have to...

    February 16, 2015 at 10:31 am

    #1777875

  • RE: Wild Card search

    SQLAssAS (2/16/2015)

    Hi..

    I have 5 columns in my report:

    ServerInstance, Database Name, Recovery Model,

    Compatibility, State

    This has all the databases across our SQL estate in it.

    Its main function is to enable me and...

    February 16, 2015 at 10:15 am

    #1777870

  • RE: Wild Card search

    SQLAssAS (2/16/2015)

    I have a report which basically lists all of the databases I have on my SQL estate.

    I have a parameter which, if I type the correct database name in,...

    February 16, 2015 at 10:07 am

    #1777866

  • RE: Ideas please

    I wrote a system that did this type of thing several years ago. It was VERY difficult to get working. As Kevin mentioned the conflict resolution was by far the...

    February 16, 2015 at 8:12 am

    #1777842

  • RE: Approximate Data types

    Great back to basics question. I am shocked at the response rate.

    Correct answers: 57% (166)

    Incorrect answers: 43% (123)

    Total attempts: 289

    I am really surprised that so many people got this wrong....

    February 16, 2015 at 7:49 am

    #1777835

Viewing 15 posts - 3,241 through 3,255 (of 15,381 total)