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:

SQL Server :: Creating Foreign Key And Primary Key?

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

SQL Server :: When To Use Primary And Foreign Key In Our Project

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

SQL Server :: Is It Possible One Foreign Key Referenced By Two Primary Keys From Different Tables

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

SQL Server :: Creating Store Procedure - How To Insert The Primary Key From The Product_Table Into The foreign Key

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

ADO.NET :: Primary And Foreign Key Auto Populate?

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

DataSource Controls :: Dml For Primary And Foreign Key Tables?

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

DataSource Controls :: Attribute To Be The Foreign Key Which Is Not A Primary Key In The Original Table?

Jul 2, 2010

attribute to be the foriegn key which is not a primary key in the original table?

View 1 Replies

DataSource Controls :: Deleting All Child Record On The Base Of Primary Key And Foreign Key?

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

Forms Data Controls :: Retrieve Primary Key From One Page In Another Page As Foreign Key?

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

Entity Framework: Substituting Primary Columns For Foreign Key Columns

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

ADO.NET :: Does Entity Framework 3.5 Support Composite Foreign Key/Composite Primary Key

Dec 14, 2010

Does ADO.Net Entity Framework 3.5 support Composite Foreign key/Composite primary key?

View 5 Replies

DataSource Controls :: How To Use Primary Key Table And Foreign Table

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

SQL Server :: Mobile Number Is Assigned As A Primary Key Showing Error "Primary Key Violation"?

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

Forms Data Controls :: Values From Multiple (non Primary And Primary) Datakeys?

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

MVC 2 Relation Without Foreign Key With Entity Framework 4 Or With Foreign Key?

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

SQL Server :: Get Primary Key Value From The Table?

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

SQL Server :: Looking For Composite Primary Key?

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

SQL Server :: How To Declare Primary Key

Aug 1, 2010

ALTER PROCEDURE dbo.Select_Customer
(
@UserId varchar(100),

[code]...

View 15 Replies

SQL Server :: Assigning A Foreign Key?

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

SQL Server :: Adding Prefix With Primary Key?

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

SQL Server :: Duplicating Row Of Table (with Primary Key)

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

SQL Server :: Dropping Primary Key On A Table?

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

SQL Server :: Difference Between Primary Key And Identity Key?

Aug 2, 2010

I want to know mail difference between primary key and identity key with example.

View 3 Replies

SQL Server :: Reset Primary Key To Number 0?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved