Forum Replies Created

Viewing 15 posts - 31 through 45 (of 92 total)

  • RE: LEN and CONVERT

    Helps to read the question carefully - great easy question though - thanks.

  • RE: What's in a name?

    IgorMi (7/19/2013)


    BIDS will stay among the folks, as shorter it is as easier to use.

    +1

    Don't understand the logic of the insistance on renaming something that everyone is happy with -...

  • RE: Temp Tables

    Thanks for the great basics question... Discovered this the hardway a few years back!!!

  • RE: Basic Date Function

    +1 to the above points.

    Great question as far as idea and content goes, but needs clarification as to where you are in the world!!

  • RE: New Year's Math

    Nice question and great explanation - didn't know about the literals in the declaration, so thanks for that too.

  • RE: Table variables

    +1

  • RE: IDENTITY INSERT

    Didn't know that limitation so learnt something new today - Thanks!:-D

  • RE: PARSENAME

    Another great question to learn from - thanks. I had heard of the function, but never knew what it did.

  • RE: Five percent rounded down

    Thanks for the question, it is a great point to learn from! I hadn't seen this before, but know there are always issues with real and float numbers so had...

  • RE: Table Variable

    DugyC (9/4/2012)


    At first glance my instinct was to go with zero, but then I noticed it was a table variable.

    Phew 😀

    Good question, thanks.

    +1

    Knew the issue with Table Variable, so...

  • RE: Inserts

    Knew about the 1000 limit but missed the start from 0!!! Doh... definitely wont try this again without coffee!

    Very sneaky question, but a good reminder...

    Agree that we do...

  • RE: Basic of T-SQL

    Rich Weissler (8/20/2012)


    Now, had there been an option of "Table A will return 10 rows and Table B will return 7 rows" ... that could have been interesting.

    Probably what the...

  • RE: ISNULL

    Was really looking for what is the catch!!! 😛

    Nice simple question as follow up to yesterdays... Thanks

  • RE: Commenting in Dynamic query

    Took me a good while to catch the difference and so what the gotcha was, as I too thought a rewrite of friday's question! Pays to take some time and...

  • RE: Index types 1

    Great Question Hugo - thanks.

    Had to do a lot of reading to check what I already seemed to know, but taught me more about what I didn't know. 🙂

Viewing 15 posts - 31 through 45 (of 92 total)