locked
POSTING TIPS - source code, screen images, details within...

    Diskusi Umum

  • 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

     

    Using the Editor:

    (Thanks to Kalman Toth for these instructions.)

    Use the Forum Editor method to Insert Image:

    1. Save the image to disk

    2. Use the Insert Image (right most) icon to upload the image

     

    Using HTML:

    (Thanks to Todd McDermid for this tip)

    1. Copy your screen to the clipboard (ALT-PRTSCN) (alternatively, some image editors can do screen captures)
    2. Paste it in your favourite image editor
    3. Upload it to a free image hosting site like Flickr, ImageShack, ...
    4. Create your post, then press the "HTML" button on the post toolbar.  This will open another browser window with HTML in it.
    5. 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">
    6. Press the Update button.


    The Volunteer Moderators and Answerers who support the Microsoft MSDN SQL Server Forums have created a Wiki to present Solutions to Common T-SQL Problems.

    Check here to see if there is a suggestion that can guide you to a solution for your problem.

       http://code.msdn.microsoft.com/SQLExamples

    If you find that the Wiki provided you with useful informtion, please let us know by posting a synopsis of your problem and a comment about your successful use of that information.

    Credit to Arnie Rowland

     “Top Solution Content” blog

    As part of our efforts to keep our communities informed about the most relevant content that address the top questions that we are getting in out forums and other support channels we want to introduce the new “Top Solution Content” blog (http://blogs.technet.com/b/topsupportsolutions).

    In this blog you will find up-to-date and valuable information about Microsoft top support solutions for several of our popular products in the Server and Tools portfolio. You can use the tags (http://blogs.technet.com/b/topsupportsolutions/archive/tags) to easily locate the product of your preference or visit the home page to see what’s going on for the different Microsoft Enterprise and developer products. As a blog you can also subscribe to post and comments using the RSS feeds.

    We hope this will reduce time and effort when you are looking for relevant content. Enjoy it!

    Thanks

    Credit to Elvis Long






    01 Desember 2009 22:19
    Moderator

Semua Balasan

  • Some guidelines from Clifford Dibble...

    When you post questions here, please strive to:

    a) Post the simplest possible repro.   Please do some up-front debugging and detective work, and post the narrowest possible repro.  It's not helpful if you post 5 pages of code.

    b) Post the DDL of your schema so that we know the data types, NULL-ability, and constraints.

    c) Please indicate exactly which version and SP of SQL Server you are using.

    d) Please indicate any additional info that may be useful, e.g., perf counters, SQL error log messages, NT event log messages, etc.

    e) Provide the text query plan if needed.

    Thanks

    Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    20 Mei 2013 14:34
    Pemilik
  • From Kalman Toth...

     

    Spanish Language Posting

    This is an English language forum. You can use the following machine translators from Spanish to English:

    http://www.spanishdict.com/translation

    http://www.bing.com/translator 

    Similarly, machine translation to English is available in the Bing Translator

    Thanks.


    Ed Price (a.k.a User Ed), SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    20 Mei 2013 14:38
    Pemilik