-
-
Too small, unreadable.
-
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? -
Hmm...Formatting is not what I expected (based on the preview), but hopefully you get the idea.dpratt71 said: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? -
-
Dodo said:qwert231 said:*snip*
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.DB_ID(N'IntranetApps')
GO
SELECT * FROM sys.dm_db_index_physical_stats
(DB_ID(N'IntranetApps'), OBJECT_ID(N'...'), NULL, NULL, 'DETAILED')
GOwhere ... 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 ]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')
GOwhere ... is the name of an object in his database.
qwert231, check out example C in DB_ID (Transact SQL) [MSDN].
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
), but apparently C9 isn't exposing it.
-
Sven Groot said:
You can get SQL formatting like this: [ code language="SQL" ] code here [ /code ]joechung said:*snip*
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
), but apparently C9 isn't exposing it.SELECT * FROM sys.databases
Edit: it works when you put "sql" in lower case letters. Yay for case-sensitivity. -
Duplicate.Sven Groot said:
You can get SQL formatting like this: [ code language="SQL" ] code here [ /code ]joechung said:*snip*
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
), but apparently C9 isn't exposing it. -
Yeah... he's a source of unanswered questions. And now we are at a question without a questionDodo said:qwert231 said:*snip*
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.

Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.