SQL Server Developer Center > SQL Server Forums > SQL Server Integration Services > POSTING TIPS - source code, screen images, details within...
Ask a questionAsk a question
 

StickyPOSTING TIPS - source code, screen images, details within...

  • Friday, October 16, 2009 9:43 PMPhil BrammerMVP, ModeratorUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Has Code
    When you're posting a question - please search the forum first!  If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below.  If you want to show us what you see on your screen (pictures are worth a thousand words), see below!
    Moderators, please add any other tips you may have.

    Including T-SQL, C#, VB.Net Source Code

    (Thanks to Phil Brammer for this tip)
    When you are composing a post and you wish to paste code, please don't directly paste it into the post, instead paste it into the code block editor.  It will preserve formatting for you, which makes it easier for us to read it and help you with your issue.

     

    Examples follow...

    Not using the code block editor:

    select

     

    *, text

     

    from sys.dm_exec_cached_plans

     

    cross apply sys.dm_exec_sql_text(plan_handle)


    Using the code block editor (and with the same copy-n-paste buffer):

     

    select *, text
    
      from sys.dm_exec_cached_plans 
    
     cross apply sys.dm_exec_sql_text(plan_handle)
    
    

     

     

    Including Images

    1. (Thanks to Todd McDermid for this tip)
    2. Copy your screen to the clipboard (ALT-PRTSCN) (alternatively, some image editors can do screen captures)
    3. Paste it in your favourite image editor
    4. Upload it to a free image hosting site like Flickr, ImageShack, ...
    5. Create your post, then press the "HTML" button on the post toolbar.  This will open another browser window with HTML in it.
    6. Find the spot where you want the image, and add a standard IMG element, pasting in the URL to your image, like this:
      <img src="http://your.url.here/your_image_filename_here">
    7. Press the Update button.

     


     

    Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer