Forum Replies Created

Viewing 15 posts - 76 through 90 (of 325 total)

  • RE: CREATE statement

    did I miss something ???

    or there are more than 2 failures ...

    select db_id('dbdb')

    -- and the second one

    select object_id('dbdb')

    I don't think it will return the same value for a database.

    I dig...

    March 6, 2013 at 11:17 pm

    #1594286

  • RE: ISNUMERIC

    happycat59 (3/5/2013)

    Mmm, why have "ISNUMERIC" as the heading for this question ? This question is not really about the ISNUMERIC function. How about getting the heading to match...

    March 6, 2013 at 12:05 am

    #1593782

  • RE: ISNUMERIC

    Lokesh Vij (3/5/2013)

    happycat59 (3/5/2013)

    Mmm, why have "ISNUMERIC" as the heading for this question ? This question is not really about the ISNUMERIC function. How about getting the heading...

    March 5, 2013 at 9:29 pm

    #1593755

  • RE: Clustered Index

    L' Eomot Inversé (3/5/2013)

    Nice question, no ambiguities. Really good explanation - I very much liked that you took the trouble to mention that TRUNCATE TABLE works even when the...

    March 5, 2013 at 9:33 am

    #1593534

  • RE: Clustered Index

    Lokesh Vij (3/5/2013)

    ggeier (3/5/2013)

    How can the index rebuild remove the fragmentation from the index? The table is empty at that step so it should already be at 0.00% fragmentation.

    Nice catch!!

    I...

    March 5, 2013 at 8:10 am

    #1593497

  • RE: SETTINGS - 1

    nice and easy Q for the monday ...

    and a great explanation by Tom ...

    thanks for Q & E

    March 3, 2013 at 9:57 pm

    #1592866

  • RE: Getting minimum of top n rows without using subquery

    winmansoft (2/28/2013)

    thanks for replies

    We want sorting sometimes,I think we will stick to

    select min[v.date]

    from

    (select top 100 [date]

    from

    WHERE [date] BETWEEN '01-Jan-2012' and '20-Jan-2013'

    order by [date] desc) V

    While...

    March 1, 2013 at 3:56 am

    #1592302

  • RE: Searching for Solution

    sqlnaive (3/1/2013)

    Hello All, I have one query (it may sound stupid though). We have one SQL Server 2008 (Microsoft SQL Server 2008 (SP2) - 10.0.4266.0 (X64)) and on my machine...

    March 1, 2013 at 1:57 am

    #1592278

  • RE: Can This Work?

    Christian Buettner-167247 (3/1/2013)

    demonfox (2/28/2013)

    tom.kane (2/28/2013)

    I got tricked with this one. I said No, because the code will cause a syntax error as you can't mix creating tables and procs...

    March 1, 2013 at 1:37 am

    #1592276

  • RE: Can This Work?

    tom.kane (2/28/2013)

    I got tricked with this one. I said No, because the code will cause a syntax error as you can't mix creating tables and procs without using a...

    February 28, 2013 at 9:49 pm

    #1592232

  • RE: Can This Work?

    I got it right, but it was a sheer guess on the mind of OP ..

    will this code execute successfully

    it should have been mentioned as the 4th step..

    also, it does...

    February 28, 2013 at 9:15 pm

    #1592230

  • RE: Updating the data in a table

    Raghavendra Mudugal (2/28/2013)

    demonfox (2/28/2013)

    yes.. and I think , it would be same as this one

    ...also significant improvement on the EP.

    +1 .. a better look , should I have said...

    February 28, 2013 at 1:25 am

    #1591894

  • RE: Updating the data in a table

    Good one. :), thank you for posting. (very cute logic...)

    yes.. and I think , it would be same as this one

    DECLARE @maxc INT

    SELECT @maxc = MAX(C1)

    FROM dbo.T1

    UPDATE...

    February 28, 2013 at 12:22 am

    #1591885

  • RE: Creating Tables 2

    EL Jerry (2/27/2013)

    I, too, was looking for a trick, but couldn't find any, and got it right.

    Thanks for the easy question, Dave.

    Saludos,

    +1

    it was easy one ...thanks for the question..attempted it...

    February 27, 2013 at 10:43 pm

    #1591869

  • RE: Updating the data in a table

    Lokesh Vij (2/27/2013)

    For me this was an easy one to attempt 🙂

    +1

    not so different for me too .. 🙂

    thanks for the question 😀

    February 27, 2013 at 10:40 pm

    #1591867

Viewing 15 posts - 76 through 90 (of 325 total)