network profile
| bio | website | |
|---|---|---|
| location | London, United Kingdom | |
| age | 30 | |
| visits | member for | 1 year, 5 months |
| seen | Jan 11 at 8:59 | |
| stats | profile views | 7 |
Theoretical physicist and software developer.
|
Jan 11 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key The simple answer is that I want both and the accepted answer gives me means to do this... |
|
Jan 11 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key I need all of the constraint information for any given column (if any). I want to construct a database class that holds all the information for a given database. This class structure database.table.column.constraints will then be used to get the matches between different columns on PK/FKs. Clearly some columns will have FKs only and in this case I also want to retrieve the PK information of the corresponding key; some will have only PKs and then I want the reverse. Some of course can have both. Sorry if this also does not answer you question. |
|
Jan 10 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key I am creating a script genrator for QlikView. To generate the script I need the constraints and the ascociated links. |
|
Jan 10 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key Thanks for your time Aaron. Much appreciated. |
|
Jan 10 |
accepted | How to Find the Foreign Key Associated with a Given Primary Key |
|
Jan 10 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key Thanks again. When I can bounty this I will do... |
|
Jan 10 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key Thanks very much for your time here. It is most appreciated. Where can I get one of those posters!? It looks like you might be able to use INFORMATION_SCHEMA.KEY_COLUMN_USAGE? This is making me feel very weak! |
|
Jan 10 |
awarded | Commentator |
|
Jan 10 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key Ps. I am going to bounty this so you can have some rep! |
|
Jan 10 |
comment |
How to Find the Foreign Key Associated with a Given Primary Key That is absolute quality. I have been hacking around with a three teir JOIN simalar to the 1st, 2nd and 4th above. Great to see an answer like this - so difinitive! Now, two additonal things if I may be so bold. How do you find out about the poentail links between such system table and thus easyly come up with the above? or is it experience? Exending this to include the actual PK name is also not obvious to me - could you extend the answer to include this please? |
|
Jan 10 |
revised |
How to Find the Foreign Key Associated with a Given Primary Key added 519 characters in body |
|
Jan 10 |
asked | How to Find the Foreign Key Associated with a Given Primary Key |
|
Nov 20 |
accepted | Another BCP Export [Fail]ure |
|
Nov 20 |
comment |
Another BCP Export [Fail]ure I have ammended the stored proceedure as above. But I am still getting an error that is documanted here connect.microsoft.com/sqlserver/feedback/details/584001/bcp can you offer any ideas as to a resolution? Thanks again. |
|
Nov 20 |
awarded | Editor |
|
Nov 20 |
revised |
Another BCP Export [Fail]ure deleted 52 characters in body |
|
Nov 20 |
comment |
Another BCP Export [Fail]ure +1, I had taken this out of context in my own mind! Thanks, but how the hell do I get a self contain SP that will allow me to build the correctly order field list if not with TmpTables? Man, this stuff drives me round the bend... Again, thanks for your time. |
|
Nov 20 |
asked | Another BCP Export [Fail]ure |
|
Nov 20 |
comment |
SELECT Data Set Using Stored Procedure with BCP Error Why? Basically, the SP is casting Empty.Strings to nulls to get around BCP putting the ASCII CHAR(0)/Nul character in the output file. Running SELECT * FROM [2BSHAEOS]..[B1A]; as the query works. I think you are right and this is occuring due to the fields specified in the format file being of an incorrect order as the fields output by my SP - this goes from bad to worse! You should see the SP that creates the .fmt file!! |
|
Nov 20 |
awarded | Scholar |
