Forum Replies Created

Viewing 15 posts - 16 through 30 (of 145 total)

  • RE: IDENT_CURRENT()

    nice question to learn new things....😎😎😎😎

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: Ending 2017

    Question is correct...But answer is wrong...:) 😀😀😀

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: PARTIAL Restores

    Partial backup is nothing but the differential backup. If we need to restore differential backup, initially restore FULL backup then differential backup.
    Full backup --> every day backup
    Differential backup...

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: The Current Date

    nice question

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: Dropping PKs

    very easy one

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: SQL Server agent job was not running last night.

    Thanks Gianluca Sartori...

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: SQL Server agent job was not running last night.

    Thanks Gianluca Sartori... How can i find out the issue by using the above query? any column looks strange when that error raise?

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: Disabling Indexes

    nice question...

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: Recompile in a stored procedure?

    nice question...

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: SOME rows

    Thanks for the question...:-D

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: COUNT NULLs

    nice question...

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: Distinct Counts

    nice question... count * should not consider the null values that's why we got an error while using count(distinct *), But when we use count(distinct myid) it consider null also...

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: Counting values

    if I run the below query then it gives result as 4. So when I mention column name inside of count function, it omitted the null values in that column....

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: Thanksgiving 2014

    Nice question thanks....

    Now only i am getting to know Thanksgiving day 😛

    Manik
    You cannot get to the top by sitting on your bottom.

  • RE: What will be the output message?

    This is because LEN function does not work for text, ntext and image data types.

    new things added in my mind memory...:-D

    Manik
    You cannot get to the top by sitting on your bottom.

Viewing 15 posts - 16 through 30 (of 145 total)