What is Primary key and foreign key? Give an example
- 4 Answers
- 10022 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / alquama rizvi
MS-Access requires a special way of recognising every record of a table. For this you have to set or make a primary key. If you do not do so, MS-Access does this itself by adding a new field , serving as the primary key. A table may have only one primary key, although it may have more than one fields.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between openrowset and openquery?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What kind of problems occurs if we do not implement proper locking strategy?
Can we do dml on views?
How to rebuild the master database?
Why we use the openxml clause?
List out the different types of locks available in sql server?
What is the primary use of the model database?
What are the different types of subquery?
How can you append an identity column to a temporary table?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How do I find the sql server version?
How to convert numeric expression data types using the cast() function?
How do I find query history in sql server?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
