Forum Replies Created

Viewing 15 posts - 331 through 345 (of 465 total)

  • RE: Unwanted parameter truncation

    GilaMonster (12/19/2012)

    pdanes (12/19/2012)

    GilaMonster (12/19/2012)

    I'm going to be unpopular here but...

    Dependency analysis?

    Regression testing?

    Unit tests?

    Sure, making all parameters and variables varchar(max) would work. Shall we make all table columns varchar max too...

    December 19, 2012 at 12:53 pm

    #1570281

  • RE: Unwanted parameter truncation

    Jeff Moden (12/19/2012)

    So, use the +1 method I told you about if there are any doubts. Either that or remember the hair pulling you just went through and make...

    December 19, 2012 at 12:35 pm

    #1570263

  • RE: Unwanted parameter truncation

    Grant Fritchey (12/19/2012)

    Whatever your data structures are, so should your parameters be, both in data type and length. What do the structures look like?

    Well, the data structure may be a...

    December 19, 2012 at 12:29 pm

    #1570262

  • RE: Unwanted parameter truncation

    GilaMonster (12/19/2012)

    I'm going to be unpopular here but...

    Dependency analysis?

    Regression testing?

    Unit tests?

    Sure, making all parameters and variables varchar(max) would work. Shall we make all table columns varchar max too (if not,...

    December 19, 2012 at 12:10 pm

    #1570258

  • RE: Unwanted parameter truncation

    Jeff Moden (12/19/2012)

    There's also a disadvantage to using (for example) VARCHAR(MAX). The MAX datatypes really don't like to be joined to and it will slow down queries.

    So I've been...

    December 19, 2012 at 11:41 am

    #1570243

  • RE: Unwanted parameter truncation

    MyDoggieJessie (12/19/2012)

    I don't believe there's a way within SQL to prohibit the truncation of the strings when it's assigned to the variable. How is this proc called? If...

    December 19, 2012 at 11:31 am

    #1570238

  • RE: LIKE with and without wildcards in WHERE clause

    GSquared (12/3/2012)

    There's no need to convert Like to = if it doesn't include any wildcards. Just use Like. SQL Server will treat it as an equality test if...

    December 3, 2012 at 9:38 am

    #1564953

  • RE: LIKE with and without wildcards in WHERE clause

    GSquared (11/30/2012)

    pdanes (11/30/2012)

    I'm working on the syntax of dynamic SQL with parameters, but I find myself coming back to the same question that actually started this thread: If I use...

    November 30, 2012 at 9:17 am

    #1564457

  • RE: LIKE with and without wildcards in WHERE clause

    I'm working on the syntax of dynamic SQL with parameters, but I find myself coming back to the same question that actually started this thread: If I use the predicate...

    November 30, 2012 at 6:24 am

    #1564330

  • RE: LIKE with and without wildcards in WHERE clause

    capnhector (11/27/2012)

    pdanes (11/27/2012)

    GSquared (11/27/2012)

    pdanes (11/27/2012)

    There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what...

    November 30, 2012 at 2:52 am

    #1564230

  • RE: Connection to SQL Server dropping

    Yes, this is Access talking over an ODBC link to a server running SQL Server. There are many individual machines running this app, and more may be added any time....

    November 29, 2012 at 3:05 pm

    #1564066

  • RE: Connection to SQL Server dropping

    Well, apparently it's some sort of a timing or saturation issue. I put a 100 millisecond pause with DoEvents after every call to SQL Server, and it works. Where it...

    November 29, 2012 at 11:16 am

    #1563943

  • RE: Connection to SQL Server dropping

    L' Eomot Inversé (11/29/2012)

    pdanes (11/29/2012)

    Neither of these keys exists anywhere on my server. The path you list is there, but those keys are not, there or anywhere else.

    I carelessly said...

    November 29, 2012 at 10:14 am

    #1563913

  • RE: Connection to SQL Server dropping

    Brandie Tarvin (11/29/2012)

    How is your environment set up?

    For instance, in one environment I worked on, we had a SQL Server, a Citrix Terminal Server, and an application / file server....

    November 29, 2012 at 8:30 am

    #1563830

  • RE: Connection to SQL Server dropping

    Randy Doub (11/29/2012)

    How about the data in the Express db? Does it fail trying to return the same record every time?

    No, it varies. It's roughly a minute, and sometimes...

    November 29, 2012 at 8:17 am

    #1563819

Viewing 15 posts - 331 through 345 (of 465 total)