Tech Off Post

Single Post Permalink

View Thread: Why doesn't this SQL work?
  • User profile image
    Sven Groot

    joechung said:
    Dodo said:
    *snip*
    DB_ID(N'IntranetApps')
    GO

    SELECT * FROM sys.dm_db_index_physical_stats
    (DB_ID(N'IntranetApps'), OBJECT_ID(N'...'), NULL, NULL, 'DETAILED')
    GO

    where ... is the name of an object in his database.

    qwert231, check out example C in DB_ID (Transact SQL) [MSDN].

    You can get SQL formatting like this: [ code language="SQL" ] code here [ /code ]
    Just remove the extra spaces around the [].

    EDIT: Ok, apparently that doesn't work. I know the code formatter they use supports SQL (since I wrote it Tongue Out ), but apparently C9 isn't exposing it.