Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
Employee Name as primary key
September 09, 2010
I am uploading excel data to databse.I dont have EmpId.Can i use EmpName as primary key.In excel file there ii first name and lastname column should i need to create two columns in database or its better to store in one column as EmpName with combination of first name and lastname.
Posted Date: September 12, 2010 Points: 5
You can have lastname and first name in different column
form a composite primary key on firstname and lastname columns.
Posted Date: September 15, 2010 Points: 5
Use Composite Primary key on first and Last Name
To post reply
Related Questions Related Questions
How to synchronize two tables in two different servers where primary key is auto numbered?
How to check whether the employee is getting weekOff for all 4 weeks
find the composite primary key in all the tables using sql server
How do I determine if a table has any primary key in Oracle?
Can we have primary key for more than two column? In which situation we will use it Give an example
Display the details of an employee
Calculate the hours worked by an employee
Doubts in primary key and foreign key concepts.
i need (logintime in one table and fixed working hours is eg:9 but a employee login at 10 o clock th
how to create primary keys on mulitple columns
Latest Forum Questions From The Same Category
Slash(/) in Combobox
attaching the report in the web page
How do i get payment status in redirect page using bitpay?
Login with Facebook and Save details in database
Login with facebook account in my website
How to make a nested datalist control?
What class does Icon derive from?
What are the validation controls?
What''s the difference between an interface and abstract class?
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend