Answer Posted / vijay

Join:-
Join are used to retrieve data from more than one
table simultancously .
Types of join are:-
1.Outer join
*--Right Outer join
*--Left Outer join
*--Full Outer join
2.Multiple join
3.self join
4.Inner join
5.cross join

How do you insert a table?

931

---

What are the technical specifications of mysql?

1163

---

Is there a free version of mysql?

942

---

How do you create a primary key?

1011

---

What are the differences between char and varchar?

1112

---

How to create a new table in mysql?

1048

---

How can we get total number of records by query in mysql?

909

---

What is mysql_pconnect?

909

---

How can you change the password of a mysql user?

965

---

What is database clustering in mysql?

1036

---

What is triggers?

963

---

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

1639

---

How show all tables in mysql query?

939

---

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1122

---

What is the limitation of mysql?

969

---