Forum Replies Created

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

  • RE: STUFF - 1

    Nice Stuff.

    T-SQL is Great

  • RE: SELECT (Transact-SQL)

    Easy question.

    It shows once again, the more options/possibilities, the more errors can be made.

  • RE: Table Variables

    Difficult question.

  • RE: Changing Identity Columns

    Nice tricky question.

    No rows inserted, therefore the answer is 100.

  • RE: STR

    L' Eomot Inversé (10/18/2012)


    Good question

    But the explanation is very poor, inaccurate. For example the length of the expression "123.45" is 6, but str(123.45,4,2) is not '**' as suggested by...

  • RE: STR

    Good thing that it is "**"

    Wrong information is no information.

  • RE: COALESCE

    Too easy...

  • RE: Noise

    Mention SQL version anyway!

  • RE: VIEW - 9

    This questions shows once more the variety of things you can do with MSSQL.

    Great!

  • RE: shrinking logfile in SQL 2008

    terryj30 (2/11/2009)


    try this

    dbcc opentran database

    go

    kill spid

    go

    alter database database set recovery simple

    go

    checkpoint

    go

    alter database database set recovery full

    go

    backup database pubs to disk = 'c:\database.bak' with init

    go

    dbcc shrinkfile (N'database_log' , 1)

    go

    Haha, it still...

  • RE: Numbers

    Where is the € Euro sign?

  • RE: DECLARE - 1

    Nice question!

  • RE: While loop 2

    Great question!

  • RE: While loop

    Keep looking for he error where there is non...

    Nice puzzle.

  • RE: T-SQL

    Nice question.

    Allways good ho learn!

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