Settings and activity
3 results found
-
1 vote
William Buchanan
shared this idea
·
-
1 vote
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
shared this idea
·
-
1 voteWilliam Buchanan
shared this idea
·
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