when i save float data value 11.22 but this see in table
11.220000004758456 type ? how to save only two decimal point.
Answer / guest
if u put 11.22 in a variable x, try this :
2.2f specifies that ,it will print exactly 2 digits to the
left of decimal point and 2 digits to the right of the decimal
point.You can use any number according to ur requirement ,like
|Is This Answer Correct ?||4 Yes||0 No|
java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page
write a database figure to implement the master detained relationship.
Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??
what is meant by write off and write on in sap?
How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table
hp asking for replication floppy to do reinstall 25254 server assistant
On which table the SSIS SQL Server logs are stored?
In one table there is 10 records without id num,without primary key and it is not sorted then how to extract last 6 record from table?
Difference between Bookmark lookup & RID lookup?
i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 188.8.131.52.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 184.108.40.206.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.
How many types of internal joins are there in SQL Server?
What is SCD (Slowly Changing Dimensions)? What are its types?