Skip to content
← Customer Feedback for Devart

Settings and activity

5 results found

  1. Show table name in query result

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  dbForge Studio for SQL Server » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    William Buchanan shared this idea  · 

  2. Popup 'select top 100'

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    You could use the snippets functionality of dbForge SQL Complete.

    The snippet can be as follows:
    SELECT TOP $count$ *
    FROM $schema$.$table_name$

    An error occurred while saving the comment
    William Buchanan commented  · 

    Not sure I understand the response... Let's say I have the following query open in my sql editor:

    SELECT
    *
    FROM
    Process.Task t
    INNER JOIN syscore.SystemFunction sf ON t.SystemFunctionId = sf.ID
    LEFT JOIN SysCore.Person p ON t.PersonId = p.Id
    WHERE
    t.RecordStatusId='CURR'

    As i'm writing the query I want to see a sample of the data in 'SysCore.Person' so that I can see what columns and data is in there. My suggestion is that I can right click on 'SysCore.Person' and choose an option to show me this sample data. At the moment I need to open a new query editor and type in select top 100 * from SysCore.Person

    William Buchanan shared this idea  · 

  3. Sql formatter

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  dbForge Studio for SQL Server » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    William Buchanan shared this idea  · 

  4. Retrieve Data select top n rows

    11 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  dbForge Studio for SQL Server » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    William Buchanan supported this idea  · 
    William Buchanan shared this idea  · 

  5. Retrieve Data select top x rows

    2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  dbForge Studio for MySQL » Features  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    William Buchanan shared this idea  ·