Explain the difference between FLOAT, DOUBLE and REAL.
Answer Posted / fsdfsdfs
double is double
float is float
| Is This Answer Correct ? | 30 Yes | 201 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
What is difference between statement and preparedstatement?
How do you insert a table?
How do I exit mysql?
What is the difference between float and double?
How do I clear the screen in mysql?
Is mysql a free database?
How do I stop a mysql command?
How large can a mysql table be?
How to delete a table.
How to write after insert event update trigger on the same table in mysql?
What is the use of pdo?
How to start mysql server?
What is cursor in mysql?
What is the difference between char and varchar?