Databases
StackOverflow2013
Usersdbo
USLazy Bob
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USLazy Bob
    primarykey
    data
    text
    plurals
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI'm not sure if this is exactly what you're looking for, but what about a hashing solution like DBMs and such use? Hash the user's password for storage, and when they authenticate, hash the password they provide and compare it to the existing hash. This is a commonly used way to store passwords. P.S. - Depending on the level of security you want/need, I'd definitely recommend salting your hashes to avoid rainbow table type attacks. See the latest issue of "2600" for an article about how Microsoft has been storing user passwords with unsalted hashes for a long time.
      singulars
      1. POStoring passwords for authentication against another system
      1. USLazy Bob
    2. COalmost forgot, if you want to get slick, you could probably build some dynamic sql and use the REPLICATE() function to create your "UNION ALL SELECT 'value1','value2'" statement however many times you want. Google the REPLICATE() function for more details on it... I'm no expert with MS SQL.
      singulars
      1. PO
      1. USLazy Bob
    3. COOk, this seems kind of odd, but it sounds like what you're saying is that you want to insert an arbitrary number of rows of the same data. If that's the case, there is probably a better to accomplish your true end goal, but you should be able to insert an arbitrary number of rows as follows: `table` is the table to insert to, field1 and field2 are the field names, and value1 and value2 are the two values that you're going to insert a bunch of times: INSERT INTO table(field1,field2) SELECT 'value1','value2' UNION ALL SELECT 'value1','value2' UNION ALL SELECT 'value1','value2' and on and on
      singulars
      1. PO
      1. USLazy Bob
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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