Hi,
Is there any way to truncate all the tables using import utility which we are going to import before actually starting the import? Now we have two separate scripts to do each job, first trun...
http://www.experts-exchange.com/Database/Oracle/Q_10259075.html
Zones:
OracleDate Answered: 02/09/2000 Rating: 4.6 Views: 0
I have an odbc application which retrieves and transfers data from and to big databases (3000 records).
The problem is that I always get the message "data truncated".
Is this because of the big s...
http://www.experts-exchange.com/Programming/System/Windows__Programming/MFC/Q_10314511.htm...
Zones:
Windows MFCDate Answered: 06/08/2000 Rating: 7.0 Views: 0
How can you truncate a Number.
Example I am getting back a number like
10203.200392991
Or course this makes no sense to the user. They need to see 10203.20
http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_10324319.html
Zones:
JavaScriptDate Answered: 04/08/2000 Rating: 9.6 Views: 4
Hi...
can the truncate command truncate many tables at one time.
i try to write :
truncate table
where table_name like 'Edit%'
'thanks.
http://www.experts-exchange.com/Database/Sybase/Q_11312778.html
Zones:
SybaseDate Answered: 09/21/2000 Rating: 6.4 Views: 0
Using this form:
$text =~ tr/\./ /;
please complete the code so that if the value of $text is "abc.txt" it truncates the ".txt" leaving behind only the "abc" so that the new value of $text is...
http://www.experts-exchange.com/Programming/Languages/Scripting/Perl/Q_11353918.html
Zones:
PerlDate Answered: 09/24/2000 Rating: 9.4 Views: 0
I am working on a large project that uses many "comments fields" in a SQL Server 7.0 database. I am using varchar for the data type since this should grow as needed for large strings. Some of the...
http://www.experts-exchange.com/Programming/System/Windows__Programming/MFC/Q_11363358.htm...
Zones:
Windows MFCDate Answered: 09/25/2000 Rating: 7.8 Views: 0
Hi!
I am using an Access program to generate e-mails that contain a long URL. IF the recipient is running Outlook 97 or Outlook 98 with Internet Explorer 5, when they click on the URL, it is loade...
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_20091439....
Need information regarding the usage of Truncate table. How does it affect the performance? What are its pros and cons?
We are using SQL Server 2000.
Rita
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20133685.html
Zones:
MS SQL ServerDate Answered: 10/14/2003 Rating: 8.4 Views: 6
When sending a report to RTF format (DoCmd.OutputTo acOutputReport, "ReportName", acFormatRTF, , False) the rtf file truncates the larger text boxes. (Problem text box has 2 Lines of 75 characters ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20136245.html
Zones:
MS AccessDate Answered: 06/18/2001 Rating: 9.8 Views: 0
I need a snippet of code that will take a text variable and return the first X words. Any help will be appreciated.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/Q_20161605.htm...
Zones:
PHPDate Answered: 08/01/2001 Rating: 7.8 Views: 0
