What is difference between primary key and foreign key?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to get the definition of a trigger back?

0 Answers  


WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,


i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,


In the primary key have a multiple field or not?

8 Answers   TCS,


Explain trigger classes i.e. Instead of and after trigger?

0 Answers  






2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,


Does a full backup include transaction log?

0 Answers  


how insert selected column only ?

3 Answers   Robert Half,


What is the security model used in sql server 2005?

0 Answers  


How to start and end transact-sql statements?

0 Answers  


What is INTVAL( )and where we use Plz any body help me

1 Answers  


What information is maintained within the msdb database?

0 Answers  


Categories