Viewing 14 posts - 646 through 659 (of 659 total)
How can provide data for u, can I attach any files in this forum?
Anyways Let me explain u clearly..there are no matching records in both the tables. my assumption regarding...
September 1, 2005 at 12:29 pm
what I mean is how can I INSERT fresh data with the joins I have, so that both tables syncronize with FK values.
September 1, 2005 at 11:37 am
yeah there is relation between Pk and FK.
OK what if I delete all the rows and try to insert it again with the this relationship. What will be INSERT command...
September 1, 2005 at 11:19 am
OK I'll give the structure of my tables and let me know how to update the table2 where I have added a FK column.
Lets say I have 2 tables in...
September 1, 2005 at 7:08 am
Is it possible to add a column in table2 as FK which is a PK column in table1 and make a relationship. The no of rows in both tables are not...
August 31, 2005 at 2:56 pm
The relationship between 1st 3 tables is in this way
say table1=offices, table2=Depts, table3=sections.
Here offices has many Depts, Depts has many sections.
August 24, 2005 at 11:41 am
I have added role to db_ddladmin, now its working fine.
Thanks a lot Greg
August 24, 2005 at 10:49 am
I added the role to db_ddladmin, now its working.
Thanks a lot Greg.
August 24, 2005 at 10:47 am
I have a fixed server role and added that user account to this role. and this role was set to have all the permissions to create a SP, But the User...
August 24, 2005 at 8:26 am
If u dont mind, can u pls let me know how can I check that?
August 24, 2005 at 8:14 am
He does not own the SP, I myself created SP and granted him all permissions tfor SP
August 24, 2005 at 8:09 am
Viewing 14 posts - 646 through 659 (of 659 total)