how can we use a composite key for two tables and how can
we represent it
Answer Posted / priya malhotra
Create 2 tables and quote the query in query analyzer...U
ll get the answer...........
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is optimization and its types?
What is user-defined inline table-valued function?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Tell me what is normalization? Explain different forms of normalization?
How do I install only the client tools of sql server 2000?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is the dbcc command and why is it used?
What do you understand by replication in sql server?
How to delete all rows with truncate table statement in ms sql server?
How much space does sql server 2016 take?
Do you know nested transaction?
What is difference between joins and subqueries?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Do you know what is normalization of database? What are its benefits?
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