• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Recent content by Condemned

  1. C

    SQL Describe - MS SQL equivalent?

    The order of the primary key fields should be the order they are returned in. INFORMATION_SCHEMA.KEY_COLUMN_USAGE.ORDINAL_POSITION gives the order of the primary key, hence the order by clause. You might want to explicity add CU.ORDINAL_POSITION to the selected fields to prove this. I've...
  2. C

    SQL Describe - MS SQL equivalent?

    OK, I've done some poking around.... The table with the last bit of information needed is INFORMATION_SCHEMA.TABLE_CONSTRAINTS. This has a column, CONSTRAINT_TYPE which (amongst others) can contain 'PRIMARY KEY'. The following query will list all tables and their primary keys. It's not...
  3. C

    SQL Describe - MS SQL equivalent?

    There's a bunch of meta-information tables that you can use for finding this sort of information. (It generally involves a lot less messing about than using sysobjects etc.) Look up INFORMATION_SCHEMA. (I'd do it myself, but it's late here and my after-midnight google-fu is amazingly weak)...
  4. C

    MySQL unique index questions

    A brief re-statement of the problem: You already have a primary key on the table, id. It is (obviously) unique, and can be used to identify a specific row. You are after some way of recognising rows that have duplicate data in the remaining columns. Can you do something like: (forgive me...
  5. C

    New Harddrive trouble?!?!

    I've just bought a 300Gb SATA drive myself, but avoided the seagate 7200.9 as it's SATA II and some (slightly older) motherboards can't understand them. I don't know if this is your trouble. I bought a Maxtor SATA II drive, because they come with a jumper setting to force them to play as a...
See more
Back
Top