SQL Server :: Foreign Key - Cannot Use Primary Key
Sep 10, 2010
In my databse i have a databse tables
UserRole -UserID,UserName,RoleName.
Compaign - CompaignId,Region,CompaignName,LOB.
Employee -EmpNo,EmpName,CompignId
Timesheet -TimeId,EmpNo,Date.
I dont have primary key for Compaign Table CompaignId is Identity column. Now i want to use CompaignId in Employee Table because based on compaign user will retrieve employee data in Front end. Again Employee table doesn't have primary key. I am uploading excel file data to databse but in excel file there is no empNo so i cannot use primaryKey i have EmpName in excel file. How to solve this issue. How to use master table if possible create table structure for my requirements.
View 5 Replies
Similar Messages:
Dec 7, 2010
I am new to sql. I got this task to design a table in sql. It has for columns user_ID(PK, FK1) , WebSite_ID (PK, FK2), Create_Dt, Update_Dt How do I create PK and Fk1 and PK FK2 in sql server 2008 R2
View 3 Replies
Oct 20, 2010
I need ms sql video, in which i can learn how to set primary and foreign key.. why it useful and how it works...
View 3 Replies
Dec 15, 2010
i'll make a simple website. in my website i have two kind of products to sell
1. Projects
2. Documents
These Tables are available in my database :
[code]...
now i will make an order table. should i make differentt order table?
or i could save order information of both tables in one table?
View 6 Replies
Aug 28, 2010
I have two tables. Product_Table with ProductID as the primary key. My other table, ProductSKU_Table which has SKU as the primary key and ProductID as the foreign key. I am trying to create a store procedure to insert into both tables. How do I insert the primary key from the Product_Table into the foreign key of the ProductSKU_Table? This is what I have so far:
[Code]....
View 15 Replies
Aug 7, 2010
In LINQ to SQL, can primary and foreign keys be autopopulated from an associated key?I'm using the asp.net userID assigned by the create user wizard as the primary key/foreign key in several tables. Right now, when a new user is created, their userID shows up in the asp.net tables but not the ones I created. I thought it would be easier if the keys could fill themselves in, like cascade, so as I have the user fill out forms, they would already have a row in the table created and it would be an of an update instead of an insert row.
View 2 Replies
Jun 3, 2010
how i insert,update and delete data in multiple table .such tables in which primary and foreign key constraint are
View 1 Replies
Jul 2, 2010
attribute to be the foriegn key which is not a primary key in the original table?
View 1 Replies
Apr 20, 2010
how can i retrieve the all foreign keys against a single primary key. i mean to say that if a table contain a primary key then it becomes as foreign keys in which tables.
i want to take that nam of that tables and on the base of that tables then i am to delete from all the entries. e.g: if a primary key's column entry deleted then all foreing key entries should also be deleted.
there are 988 tables in a single database. it can't be possible to go for each table to setup foreign key to ON DELETE CASCADE.
.can it have any way to delete against foreign key priority wise? mean to say that parent table contain primary key, child table contain foreign key , now there is another child table which dependent previous child table. then how can i delete all record against it?
i want to do it from programatically. i am using sql server 2005
i have completed this till to that , it retrieves all foreign keys but how to delete now on the base of priority.
[Code]....
View 1 Replies
Jul 29, 2010
I have two tables - Advert and Student
adID is the primary key (Advert) and acts as the foreign key for Student
I have two pages, both of which each have a detailsview in insert mode
what I want to achieve is to create a new record in advert.aspx (e.g. adID = 4), then when item is inserted, redirect to page student.aspx (which a student record is created) where the foreign key is the ID from the advert just created (e.g. student.aspx?adID=4).
View 1 Replies
Jun 30, 2010
I've created a new ASP.NET website. I've generated an Entity Data Model from my database and have dropped a entitydatasource and gridview onto my page and wired up the gridview to pull from the entitydatasource. Now I get columns like this: id extension prefix did_flag len ten_id restriction_class_id sfc_id name_display building_id floor room phone_id department_id
In each case where the item is named something_id this reflects a foreign key relationship in the database - and I did choose to have the EDM expose foreign key relationships. I'd like to make it so the gridview pulls in the values for these foreign keys rather than just showing the ID numbers - so, for example, department_id might have a value of "101" right now but it should pull from the department table "Marketing".
View 1 Replies
Dec 14, 2010
Does ADO.Net Entity Framework 3.5 support Composite Foreign key/Composite primary key?
View 5 Replies
Jan 1, 2010
How i use primary key table & foreign key table data for retriving the data with each other.I had make both table i confuse how to use it.
View 1 Replies
Nov 27, 2010
In the database one number like a 91-9685748596 and, 2nd number like 9122-9685748596 and another one is 9685748596 .when we are try to formate it using substring function it all are may be9685748596,9685748596,9685748596.Mobile number is assigned as a primary key.so its showing error "Primary key violation".We can not the remove primary key also and there are 50 lack data in our database.
View 6 Replies
Mar 6, 2011
I have the following gridview (ID=Gridview1)
I have added pid (primary key), chkblood,chkurine,chkstool,chkmalaria as datakeynames.
what I want to pull off here is .... when I click select I'll be redirected to this wizard
[Code]....
I did that....now I want to hide / skip steps in the wizard depending on the condition of checkboxes (chkblood, chkurine,chkstool,chkmalaria)
but I cant get the value from these non-primary datakeynames...
View 2 Replies
Sep 13, 2010
1 - Is it necessary to have foreign key to obtain a Relation in Entity Framework between each entity.?
2 - I have a Language Table and many many table with a foreign key related to the language table. Is it right to add this foreign key or I should do something else ?
Ex:
Language
LangID
LangName
TableTextA
TblAID
TextInfo
LangID
TableTextB
TblBID
TextInfo
LangID
TableTextC
TblCID
TextInfo
LangID
etc ...
View 1 Replies
Oct 26, 2010
I am inserting data into two tables on a button click.
I need to insert the primary key generated for Table A into the Table B as a foreign key.
How do i get the primary key value and insert into Table B?
View 10 Replies
Dec 20, 2010
Why do we need to have Composite Primary Key
Can't we set one column as Primary and others as Unique key.
View 4 Replies
Aug 1, 2010
ALTER PROCEDURE dbo.Select_Customer
(
@UserId varchar(100),
[code]...
View 15 Replies
Mar 10, 2011
I have two tables, which is table 'A' and table 'B'. Table B contains a foreign key that is referenced to table 'A'. The question now is, could I used an option in my project in visual studio an 'Others specify'? I believed that it's not possible, isn't it?If I have a selection that is bound to a datasource then is it possible to make an option 'Others specify' without adding the specified value to the database, which in turn would not have a unique ID? Table B contains the table A ID PK field, and all values from table A to table B should contain a unique ID.
View 2 Replies
Mar 31, 2011
I've a scenerio where i've to create a primary key with prefix Rad####. For example Rad0001. How to do that.
View 2 Replies
Mar 24, 2011
I need to copy the records of a row to the next available row in the same table. I tried with "Insert ...Select " but it throws me a error since the pk is auto-increment. Also, i cant specify each and every column inside the insert...select statment cause i've almost 30 columns.
View 5 Replies
Mar 29, 2011
I am working on a database with about twenty tables. In one of the tables "Customers" their is a column with
a primary key. Call it "CustomerNumber".
The problem is that we log customers from multiple vendors and so we might have the same customer number, but from different vendors. So really this would be a perfect situation where we could set up the primary key to be a composite key consisting of the Vendor and CustomerNumber combination.
The integrity of the database is not very well maintained because the Primary Key CustomerId is never used as a secondary key in any of the other tables.
So here is my question. Instead of making a primary composite key, can I just drop the primary key all together?
This is one of those questions I really hate to ask, because typically I would never lean tword this drastic of a measure to solve a problem. Because of other situations I can't discuss this might be the best alternative. So would it be okay to drop the primary key constraint all together?
View 1 Replies
Aug 2, 2010
I want to know mail difference between primary key and identity key with example.
View 3 Replies
Sep 30, 2010
I am working with a sql 2008 server express database in asp.net. I have a table which I will call table 1. Table 1 has a primary key called Order_Id which is an int and automatically increments. After deleting all the records from Table 1, how can I reset the primary key Order_Id to zero again?
View 3 Replies
