Query to find all the tables with date columns in it
Hi, Can anybody let me know the query to find all the tables that has a date columns on it. Thanks ...
datatypes
Datatype for storing video in SQL Server 2000
What datatype would be used for storing video files in sql server2000? ...
How do I convert NSDecimalNumber to NSInteger?
OK, I'm using a JSON-enabled Rails web-service to provide data to an iPhone application. I'm finding my Integer values (IDs) are being interpreted by the json-framework as a NSDecimalNumber type. I need it as an integer. How can I get an integer value out of my NSDecimalNumber typed variable? I have tried everything I know, and I'm at my...
Serial port communication in VC++
when reading data through serial port VARIANT data; BSTR k; if(m_mscom.GetCommEvent() == 2) { data = m_mscom.GetInput(); k = data.bstrVal; } What is BSTR k; and what do you mean k=data.bstrVal? What is bstrVal? ...
(PHP) Object of class SoapClient could not be converted to string
This code works fine: $result = $client->__call("optionalInfo", array( new SoapParam("...", "client"), new SoapParam("...", "add_code")) ); When I try abstracting it a bit to make the script re-usable, I get this error: Catchable fatal error: Object of class SoapClient could not be converted to string The broken code is: ...
Java: Trouble with Generics & Collection type detection
I have a class called DataSet with various constructors, each specifying a different type of variable. It might look a bit like this: public class DataSet { private HashSet Data; public DataSet( DataObject obj ) { Data = new <DataObject>HashSet(); Data.add( obj ); } public DataSet( ObjectRelations...
Hibernate and currency precision
I have a hibernate mapping as follows: <hibernate-mapping> <class name="kochman.elie.data.types.InvoiceTVO" table="INVOICE"> <id name="id" column="ID"> <generator class="increment"/> </id> <property name="date" column="INVOICE_DATE"/> <property name="customerId" column="CUSTOMER_ID"/> <property name="schoolId" column="S...
Anyone using short and byte primitive types, in real apps?
I have been programming in Java since 2004, mostly enterprise and web applications. But I have never used short or byte, other than a toy program just to know how these types work. Even in a for loop of 100 times, we usually go with int. And I don't remember if I have ever came across any code which made use of byte or short, other than ...
When to use a Float
Years ago I learned the hard way about precision problems with floats so I quit using them. However, I still run into code using floats and it make me cringe because I know some of the calculations will be inaccurate. So, when is it appropriate to use a float? EDIT: As info, I don't think that I've come across a program where the accu...
What is the purpose of long, double, byte, char in Java?
So I'm learning java, and I have a question. It seems that the types int, boolean and string will be good for just about everything I'll ever need in terms of variables, except perhaps float could be used when decimal numbers are needed in a number. My question is, are the other types such as long, double, byte, char etc ever used in no...
AlmostEqual2sComplement or BigDecimal Scaling
Using Java: The more I read on floating point value comparison, the more I get lost. In case of currency which is usually gets rounded off, what whoule you prefer..using Epsilon or a Big Decimal comparison with scaling? For instance, your data would range from 0.00 - 49,999.99? ...
JavaScript function parameter
I am trying to pass a number to my JavaScript function, but actually a wrong value is getting passed. I am giving the entire code here: <html> <head> <script type="text/javascript"> function test(num) { /*It should alert as 01004 or 1004 but to my surprise it's alerting as 516!*/ alert(num); } </script> </head> <body> <a href="javascrip...
Is there any reason for numeric rather than int in T-SQL?
Why would someone use numeric(12, 0) datatype for a simple integer ID column? If you have a reason why this is better than int or bigint I would like to hear it. We are not doing any math on this column, it is simply an ID used for foreign key linking. I am compiling a list of programming errors and performance issues about a product, ...
C#: Should a standard .Net string be stored in varchar or nvarchar?
We have an application written in C#, using .NET Framework 3.0 or 3.5 or something like that. As storage we use SQL Server, and we use Linq 2 SQL to talk with it. Currently most (if not all) text columns in the database, are set to the varchar type (of different lengths of course). But I started thinking... according to MSDN "The stri...
Disadvantage of choosing large MAX value for varchar or varbinary
What's the disadvantage of choosing a large value for max when creating a varchar or varbinary column? I'm using MS SQL but I assume this would be relevant to other dbs as well. Thanks ...
Tinyint vs Bit
I don't want to touch-off a religious war here, but there seem to be two schools of thoughts in how to represent boolean values in a database. Some say bit is the appropriate data type, while others argue tinyint is better. The only differences I'm aware of are these: bit: storage size is 1 bit, possible values are 0 or 1 tinyint: sto...
SQL: What do you use to store a ratio (percentage) in a database?
Should I use decimal or float to store a ratio in a database? Particularly in SQL2005. ...
in Oracle 9.2, how to compare LONG Type containing String text to a Column of VARCHAR2.
simple q. in Oracle 9.2, how to compare LONG Type containing String text to a Column of VARCHAR2. select * from table1 t1, table2 t2 where t1.long_value = t2.varchar2_value how can i execute such a query the easiest way? ...
Why does Math.floor return a double?
I was just wondering...official javadoc says that it returns a double that is "equal to a mathematical integer", but then why shouldn't it return an int? ...
Datetime type
i have store this kind of datetime: 06.09.2009 12:30:45 . i have been using xml datastore type. i set "06.09.2009 12:30:45" in xml file . "06.09.2009 12:30:45" is there datatype? or Datetime type? ...