Databases
StackOverflow2013
Postsdbo
 
Search
scanning

Scanning is the default search option for small tables.

Enter text here to perform a scan over supported column types.

Text columns with limited length use a substring search If the entered text is a number, integer columns will be scanned for an exact match of the value.

The scanning search option is disabled for large tables.

seeking

Seeking is the default search option for large tables.

Seeking requires indexes and can only be done using the column (or columns) the index is defined on.

In the single-column case, the database will seek to the position the entered search term would be at and return all rows greater or equal to that value.

In the multiple-column case, the above still applies to the column you supplied non-empty search text for. All previous columns, however, will be using an equality match.

Id
› search options
AcceptedAnswerId
CreationDate
FavoriteCountLastActivityDate
LastActivityDate
LastEditDate
LastEditorUserIdLastEditDate
ParentIdCreationDate
OwnerUserIdCreationDate
PostTypeIdCreationDate
ScoreLastEditDate
Title
ViewCountLastEditDate
 
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConvert Decimal to Double?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USEggs McLaren
  2. POPercentage width child element in absolutely positioned parent on Internet Explorer 7
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Mortensen
    1. USKevin Dente
  3. PO
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. POConvert Decimal to Double?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USKevin Dente
  4. POHow do I calculate someone's age in C#?
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJeff Atwood
  5. POCalculate relative time in C#
    primarykey
    data
    text
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJeff Atwood
  6. PO
    primarykey
    data
    text
    <p>Here's how I do it</p> <pre class="lang-csharp prettyprint-override"><code>var ts = new TimeSpan(DateTime.UtcNow.Ticks - dt.Ticks); double delta = Math.Abs(ts.TotalSeconds); if (delta &lt; 60) { return ts.Seconds == 1 ? "one second ago" : ts.Seconds + " seconds ago"; } if (delta &lt; 120) { return "a minute ago"; } if (delta &lt; 2700) // 45 * 60 { return ts.Minutes + " minutes ago"; } if (delta &lt; 5400) // 90 * 60 { return "an hour ago"; } if (delta &lt; 86400) // 24 * 60 * 60 { return ts.Hours + " hours ago"; } if (delta &lt; 172800) // 48 * 60 * 60 { return "yesterday"; } if (delta &lt; 2592000) // 30 * 24 * 60 * 60 { return ts.Days + " days ago"; } if (delta &lt; 31104000) // 12 * 30 * 24 * 60 * 60 { int months = Convert.ToInt32(Math.Floor((double)ts.Days / 30)); return months &lt;= 1 ? "one month ago" : months + " months ago"; } int years = Convert.ToInt32(Math.Floor((double)ts.Days / 365)); return years &lt;= 1 ? "one year ago" : years + " years ago"; </code></pre> <p>Suggestions? Comments? Ways to improve this algorithm?</p>
    singulars
    1. This table or related slice is empty.
    1. POCalculate relative time in C#
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USKnickerless-Noggins
    1. USJeff Atwood
  7. PODetermine a User's Timezone
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USKevin Dente
  8. PODifference between Math.Floor() and Math.Truncate()
    primarykey
    data
    text
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USAnonymous User
  9. POFilling a DataSet or DataTable from a LINQ query result set
    primarykey
    data
    text
    <p>How do you expose a LINQ query as an ASMX web service? Usually, from the business tier, I can return a typed <code>DataSet</code> or <code>DataTable</code> which can be serialized for transport over ASMX.</p> <p>How can I do the same for a LINQ query? Is there a way to populate a typed <code>DataSet</code> or <code>DataTable</code> via a LINQ query?</p> <pre><code>public static MyDataTable CallMySproc() { string conn = "..."; MyDatabaseDataContext db = new MyDatabaseDataContext(conn); MyDataTable dt = new MyDataTable(); // execute a sproc via LINQ var query = from dr in db.MySproc().AsEnumerable select dr; // copy LINQ query resultset into a DataTable -this does not work ! dt = query.CopyToDataTable(); return dt; } </code></pre> <p>How can I get the result set of a LINQ query into a <code>DataSet</code> or <code>DataTable</code>? Alternatively, is the LINQ query serializeable so that I can expose it as an ASMX web service?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNhan
    1. USGeoff Dalgas
...and more
 

Querying!

 
Guidance
A table list

Lists show table rows with slightly less information than detail views, therefore not requiring section labels.

This list shows the beginning of an entire table.

Search

Searching on lists works via indexes when the table is large. On the left you see input fields generated from viable indexes and an expandable report for all indexes that are unavailable for searching with the respective reasons.

Searching along indexes is called seeking and this is one of the main values that databases offer. The trivial alternative is scanning, which is potentially inefficient as it works by walking the entirety of the candidate rows to find the matches.

The offer to scan is given for small tables. Currently, this only works on text and integer columns and they are searched all at once.

Loading more

Loading more rows than the initial 10 results is also currently restricted to a single reloading of 100 entries.

A future version will keep auto-loading on scroll for tables that have suitable indexes.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload