Comment Feed for Why doesn't this SQL work? (TechOff on Channel 9)

Re: Re: Why doesn't this SQL work?

Christian Liensberger — Fri, 02 Jan 2009 15:19:00 GMT

Yeah... he's a source of unanswered questions. And now we are at a question without a question :D

Re: Re: Re: Re: Why doesn't this SQL work?

Tommy Carlier — Fri, 02 Jan 2009 15:04:11 GMT

Duplicate.

Re: Re: Re: Re: Why doesn't this SQL work?

Tommy Carlier — Fri, 02 Jan 2009 15:03:42 GMT

[code language="sql"]SELECT * FROM sys.databases[/code] Edit: it works when you put "sql" in lower case letters. Yay for case-sensitivity.

Re: Re: Re: Why doesn't this SQL work?

Sven Groot — Fri, 02 Jan 2009 13:59:53 GMT

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 :P ), but apparently C9 isn't exposing it.

Re: Re: Why doesn't this SQL work?

Joe Chung — Wed, 31 Dec 2008 06:29:49 GMT

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].

Re: Why doesn't this SQL work?

Dorian Muthig — Wed, 31 Dec 2008 05:39:15 GMT

qwert231 said:

I'm not sure why this isn't working

And I'm not sure why you posted this extremely small screenshot instead of copy'n'pasting the code as text. I tried text detection and sharpening filters on the image and still couldn't read it.

Re: Re: Why doesn't this SQL work?

dpratt71 — Tue, 30 Dec 2008 00:12:10 GMT

Hmm...Formatting is not what I expected (based on the preview), but hopefully you get the idea.

Re: Why doesn't this SQL work?

dpratt71 — Tue, 30 Dec 2008 00:10:39 GMT

It is a bit small, but the first couple lines appears to be:

DB_ID(N'IntranetApps')

GO

What is this code supposed to be doing? My first guess was that you were trying to switch the connection's current database to "IntranetApps", which would look like this:

USE IntranetApps

GO

But the rest of the code doesn't require that. Remove it?

Re: Why doesn't this SQL work?

ZippyV — Mon, 29 Dec 2008 22:51:01 GMT

Too small, unreadable.