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


Please Help Members By Posting Answers For Below Questions

How to replace null values in expressions using isnull()?

842


Explain “not null constraint” in sql server?

723


What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

847


Do you know what is difference between index seek vs. Index scan?

689


How to create a dynamic cursor with the dynamic option?

720






1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1726


Difference between connected and disconnected database in .net with sql server?

772


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

721


What are subquery and its properties?

732


How to disconnect from a sql server using mssql_close()?

774


What is Dependency Injection and provide example?

814


between cast and convert which function would you prefer and why?

729


Explain raiserror in sql server?

753


What are triggers? How do you invoke a trigger on demand?

965


What is the optimization being performed in oracle and SQL Server?

797