Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

New Code formatting engine rolled out Expand / Collapse
Author
Message
Posted Thursday, October 8, 2009 1:04 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 36,983, Visits: 31,508
GilaMonster (10/8/2009)
Testing....

Using an inequality character
SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using escape codes for inequality
SELECT session_id FROM sys.dm_exec_requests WHERE session_id > 50

Using angle brackets to designate a placeholder
USE <Database Name>

Using escape codes to designate a placeholder
USE <Database Name>

Edit: Ok, can someone tell me the secret to posting angle brackets please?


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #800284
Posted Thursday, October 8, 2009 1:06 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 36,983, Visits: 31,508
Testing Gails Problem...

SELECT 1 WHERE A > B

SELECT 1 WHERE A > B



--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #800286
Posted Thursday, October 8, 2009 1:07 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:03 PM
Points: 36,983, Visits: 31,508
Ah... got it. If you type the code in between the code markers, you get the & gt ; character representation. If you paste between the code markers from SSMS, it works just fine.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #800287
Posted Thursday, October 8, 2009 1:08 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 42,818, Visits: 35,943
That doesn't really help me. I've got a fair few 'templates' that I have set up for quick insert via a firefox plugin. Cutting them to management studio and pasting back's time consuming.

Ben, can you maybe look into the < and > please. Should be able to type them in in code blocks.

More testing... Created one of my clippings by copying from SSMS...

DBCC CHECKDB (&lt;Database Name&gt;) WITH NO_INFOMSGS, ALL_ERRORMSGS

directly pasted
DBCC CHECKDB (&lt;Database Name&gt;) WITH NO_INFOMSGS, ALL_ERRORMSGS

Forums don't like me evidentially....

Once more with feeling. Written in management studio, copy, paste

SELECT Something FROM SomeWhere WHERE Col1 &lt;&gt; Col2

:-(



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #800288
Posted Thursday, October 8, 2009 1:23 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:16 PM
Points: 4,389, Visits: 9,526
SELECT &lt;column list&gt;; FROM &lt;your table here&gt;

SELECT &lt;column&gt;

Like this?

Edit: interesting, worked on preview - then gets modified as above.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #800303
Posted Thursday, October 8, 2009 1:32 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 42,818, Visits: 35,943
Jeffrey Williams-493691 (10/8/2009)
Edit: interesting, worked on preview - then gets modified as above.


Yeah, I noticed that earlier.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #800305
Posted Thursday, October 8, 2009 1:37 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:16 PM
Points: 4,389, Visits: 9,526
I played around with it a little and preview works fine, even if you put in < and > - not sure what is going on there.

Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #800309
Posted Thursday, October 8, 2009 1:39 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:16 PM
Points: 4,389, Visits: 9,526
Jeffrey Williams-493691 (10/8/2009)
I played around with it a little and preview works fine, even if you put in < and > - not sure what is going on there.


Dang it - replaced my
&lt; and &gt;

. Weird...

SELECT <<test>> -- edited



Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #800311
Posted Thursday, October 8, 2009 1:52 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:33 PM
Points: 42,818, Visits: 35,943
Hmmm...

SELECT Something FROM SomeWhere WHERE Col1 &lt;&gt; Col2

DBCC CHECKDB (&lt;Database Name&gt;) WITH NO_INFOMSGS, ALL_ERRORMSGS

Forums definitely don't like me.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #800321
Posted Thursday, October 8, 2009 2:14 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 4:16 PM
Points: 4,389, Visits: 9,526
SELECT &lt;Something&gt; FROM SomeWhere WHERE ...

Well - that didn't work either...


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #800334
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse