Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference b/w composit key n primary key and
forigion key?
- 4 Answers
- 7971 Views
- I also Faced
- E-Mail Answers
Answer Posted / reem
A primary key is a column which uniquely identifies the
records in a table.
A foreign key is a column (the child collumn) in a table
which has a corresponding relationship and a dependency on
another collumn (the parent collumn) that is usually in a
different table.
comosit key is more than one attribute can used as aprimary
key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
Explain the difference between procedure and function in mysql?
If we use sum function in mysql, does it return sum of that row or for that column?
What is blob datatype in mysql?
What is the maximum connection pool size?
Is mysql case-sensitive?
Do I need python for mysql?
What is general log in mysql?
What is difference between microsoft sql and mysql?
What is the command line end user interface - mysql?
What happens if you no create privilege in a database?
Why is the basic difference between left join, right join and inner join?
What do you understand by mysql terminal?
How to rename an existing column in a table?
How do I completely remove mysql from windows?
