Forum Replies Created

Viewing 8 posts - 1 through 9 (of 9 total)

  • RE: DB File Extension

    LDf are used for the Transaction Log not for the Database itself.

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

  • RE: SQL to T-SQL Joins conversion question?

    You also are going to get an error if you use the symbol " to indicate the existence of a string, the compile process assumes that the word between the...

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

  • RE: Counting

    Hello, ahi va:

    You shouldn't put the @Male or @Female parameters in your COUNT statement, the select statement is working counting every row in the Group By clause.

    For only one column...

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

  • RE: Which is better? (SQL Server Best Practices)

    Ahi va:

    Where LEN(isnull(Message, '')) > 0

    Saludos,

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

  • RE: SQLServerCentral Friday Crossword No 2

    I hope you will publish te answer (I couldn't resolve all the crossword :S)

    P.D.: Sorry about my English

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Amazing ... you really open my eyes, what a good article.

    Best wishes from Peru.

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

  • RE: The New MVPs

    Congratulations!!! 🙂

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

  • RE: Row-By-Row Processing Without Cursor

    Hello from Peru 😀 ,

    How can i apply this if I'm using sql server 2000? (because the problem of the variable @sql =varchar(8000), in sql server 2000 doesnt exist...

    José Miguel Gutiérrez Hilaccama
    Database Developer - MCTS SQL Server 2005
    No way Jose? ... bah

Viewing 8 posts - 1 through 9 (of 9 total)