Forum Replies Created

Viewing 15 posts - 181 through 195 (of 205 total)

  • RE: What will happen?

    SELECT DATEADD(day, DATEDIFF(day, '20100101', CURRENT_TIMESTAMP), '20100101');

    The only thing I don't like about this method is the hard-coded string. I suppose a dynamic expression could replace it but it would...

  • RE: What will happen?

    mbova407 (9/1/2010)


    This is how we get the date for the current day without time element

    DECLARE @a INT

    DECLARE @b-2 DATETIME

    set @b-2 = GETDATE()-.5

    SET

  • RE: TempDB

    I guess if we really want to split hairs and get technical, it is possible to drop tempdb. Stopping and starting the SQLService or rebooting the server will result...

  • RE: Round up or down I

    Nice question. Had to jump start the grey matter first thing in the morning to get this one.

    I especially appreciated all the neatly terminated statements. 😉

  • RE: Are we in all these cities?

    Hugo Kornelis (7/13/2010)


    ...

    I hope the author will stop by and tell us what he/she was trying to teach us with this question. Maybe I missed the deeper issue here.

    I actually...

  • RE: How many Records Will Get Selected

    I'm not too sure this was really a bad question. We've seen questions receive a lot more positive feedback that were only worth 1 point. So if this...

  • RE: Continuing Education

    I've been in the IT field for about a quarter of a century. I do about 2 weeks of development and SQL Server training per year. I finished...

  • RE: ANSI_NULLS

    Very interesting question. I found that adding this case:

    SELECT 'E' FROM @T WHERE A IS NULL;

    will return a row with ANSI_NULLS ON or OFF. This may be the...

  • RE: No More NULL

    You got me all the way to the end. 😛

    I guess the reason I didn't consider that it could be a joke is because of my days working with PeopleSoft...

  • RE: SSMS - feature

    nigelg99 (3/24/2010)


    ...

    Yes, it is version 10.0.2531.0. I don't remember changing it, but I can see that there is an option (Options->Text Editor->All Languages) called "Enable single-click URL navigation". ...

  • RE: SSMS - feature

    nigelg99 (3/24/2010)


    I use SSMS 2008 and I get the pop-up....

    That's interesting since a number of people have posted that with SSMS 2008 no pop-up happens. Are you using 10.0.2531? ...

  • RE: SSMS - feature

    sknox (3/24/2010)


    ...

    SSMS 2005 - popup came up "CTRL-Click to open...", CTRL-click opens in a new tab.

    SSMS 2008 - NO POPUP, CTRL-click opens in a new tab.

    So I'm guessing they removed...

  • RE: SSMS - feature

    I had the same experience I see a lot of others posting.

    With a SQL Server 2008 installation on a machine with Internet Explorer as the default browser and access to...

  • RE: The Missing Certification

    I couldn't agree more that "it depends" is going to be the rule for this one. So I'll just share from my own experiences. Over the last 25...

  • RE: T-SQL: Why “It Depends”

    Test it? Isn't putting it into production the way to test things? :hehe:

Viewing 15 posts - 181 through 195 (of 205 total)