Forum Replies Created

Viewing 15 posts - 136 through 150 (of 322 total)

  • RE: AND & OR

    I do bitwise operations fairly often, yet was thrown off at first by the & operator. My probelm is I'm also a VB programmer where it is used for string...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 14, 2009 at 4:41 pm

    #1066045

  • RE: Excel with Stored Procedures

    I'm pretty sure you could avoid the VBA altogether if you replace the Stored Procedure with a parameterized table-valued User Defined Function.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 9, 2009 at 8:50 am

    #1064125

  • RE: replicate

    Nice question. Hopefully I'll trip over this one enough times to prevent me from making that mistake when it counts.

    Thanks,

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    October 8, 2009 at 11:34 am

    #1063633

  • RE: B-tree

    SQL Server indexes are organized in a B-tree structure. The "B" in B-tree stands for what?

    The question is specifically referring to SQL Server indexes. The Microsoft definition would make the...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    September 30, 2009 at 10:10 am

    #1060072

  • RE: T-SQL Parsing Crazy Eights

    I agree with Tao that thoughtful aliasing, as opposed to A. B, C, will make code easier to read for the programmer, debugger, or DBA. Most who have been around...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    September 30, 2009 at 6:46 am

    #1059911

  • RE: UPDATE

    amit_adarsh (9/24/2009)

    Yes

    and we can use all the DML operation while updation

    I think you meant to say updationing.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    September 24, 2009 at 4:10 pm

    #1058301

  • RE: @@DBTS

    I think it's a case of interpretation.

    I think I get it now. Both answers are correct if we assume that the value of the most recent usage of the timestamp...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    September 23, 2009 at 12:39 pm

    #1057706

  • RE: @@DBTS

    Steve is correct to award points. While testing the script indicates only answer #3 is correct. it's possible to find Microsoft documentation supporting answer 2 and also supporting answer 3.

    The...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    September 23, 2009 at 9:35 am

    #1057596

  • RE: T-SQL Parsing Crazy Eights

    I thought it was going to be a dull day.

    Thanks,

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    September 22, 2009 at 9:40 am

    #1056898

  • RE: Unique constraints

    I had the correct answer selected, then looked it over 1 last time and saw the tags. I changed my answer and promptly got it wrong. To be fair though,...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    July 29, 2009 at 7:31 am

    #1031665

  • RE: one character of data

    Toreador (6/16/2009)

    If you later find out it should be unicode, you can change it.

    I assume you've never been through the process of converting a large database from varchar/char/text columns to...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 16, 2009 at 10:05 am

    #1010310

  • RE: one character of data

    Maybe it's because I'm European, but I'm afraid I don't understand the (many) respondents who claim that if the character type is unknown, you should choose the most limited option?...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 15, 2009 at 5:54 pm

    #1009978

  • RE: one character of data

    Hugo,

    Never have I learned so much from a single dimwitted attempt at humor. Thanks for the info. I wish I could find the humility emoticons.:blush:

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 13, 2009 at 12:14 pm

    #1009137

  • RE: one character of data

    The correct answer for ME is char(1). I work in the U.S. and don't design for international unless it is in the specs.

    🙂Hugo - How do you store a NULL?🙂

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    June 12, 2009 at 4:21 pm

    #1008934

  • RE: Conversion Fun

    Bob Hovious (2/19/2009)

    Undocumented but useful: sp_MSGoBackInTime

    It's no longer undocumented.:cool:

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

    March 11, 2009 at 9:06 am

    #957573

Viewing 15 posts - 136 through 150 (of 322 total)