hi,
is it possible to convert a varchar to an integer with a query? something like "select * from table where INT(field) > 90"?
field is of type varchar
thanks for any help
http://www.experts-exchange.com/Database/Miscellaneous/Q_20172666.html
Zones:
DatabasesDate Answered: 08/23/2001 Rating: 8.6 Views: 0
Hi
i have the following SQL statement
psql="Update customers set pointstotal="& points
psql= psql & " , pointsremaining =" & pointsremain
psql=psql & " , sponsoree= '" & Sponsoree & "'"
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20864148.html
Zones:
MS SQL ServerDate Answered: 01/27/2004 Rating: 7.0 Views: 0
In below oracle PSQL code I want to get more detail of exception. Like in which field and table, error related. So is there any object for error types.
----------------------------------------...
http://www.experts-exchange.com/Database/Oracle/9.x/Q_22719989.html
Have a table with employees and each employee record has a supid & supname included. What I need is to create a recursive query that will tie every sup to a list of his employees.
For example:
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23203927.html
Hi!
I got a novice question regarding Tomcat!
We have a server with Tomcat installed.
- Is it possible to use MOD_PLSQL through tomcat or do we have to install apache as well???
rgs
Jan
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/Apache/Q_20322500.htm...
I would like to capture the results of a command such as:
select * from mytable;
into an output file. The documentation suggest one can use psql -- from the command line, but I would like to...
http://www.experts-exchange.com/Database/PostgreSQL/Q_22011731.html
Zones:
PostgreSQLDate Answered: 10/04/2006 Rating: 9.8 Views: 0
How can I connect to Pervasive SQL from windows Excel; what drivers do I need, I am looking for ODBC drivers but Pervasive website says it is provided with original sofware, Is there any place I ca...
http://www.experts-exchange.com/Database/SQLBase/Q_23324602.html
Hello,
I am attempting to import some csv files into existing tables in my Postgresql database.
Instead of easily copying the data into my tables I seem to be doing something wrong.
Each of the ...
http://www.experts-exchange.com/Database/PostgreSQL/Q_24328986.html
Hello,
I am new to PostgreSQL and I need to move the databases from one server to another? I have read about a dumpall feature that will allow me to do this.. However, when I type in the command...
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Q_24573062.html
Zones:
Microsoft OSDate Answered: 07/22/2009 Rating: 9.1 Views: 0
Hi Experts,
Currently I am able to psql into a database without a password. I don't want this - I want to be prompted for a password - what's the fix?
Thanks,
Mike
http://www.experts-exchange.com/Database/PostgreSQL/Q_23314466.html
Zones:
PostgreSQLDate Answered: 09/17/2008 Rating: 8.2 Views: 123
