I have inherited a MS-SQL 6.5 system and brand to to it. One table has over 7million records, of which I need to purge out. It seems I can only sql-delete about 100,000 records at one time - safe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20132604.html
Zones:
MS SQL ServerDate Answered: 06/12/2001 Rating: 7.4 Views: 4
Hi,
Is it possible to perform an ISQL of a stored procedure where the results are outputted to a file and the CRLF's at the beginning of a record are excluded?
This is on a Windows based syst...
http://www.experts-exchange.com/Database/Sybase/Q_20393945.html
Zones:
SybaseDate Answered: 11/14/2002 Rating: 7.6 Views: 0
I have installed a MSDE on a Win98 machine. And I would like to use isql and bcp commands for copying data from .dat files into the database. But I do not know what files (e.g *.exe, *.dll) I need ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20434059.html
Zones:
MS SQL ServerDate Answered: 12/26/2002 Rating: 9.8 Views: 0
Hi,
I 'm using isql -page 5000 -i Controler.SQL
to run some questions in a batchfile
But now i still have to add the outputfile in the controler.sql
egg.
CONNECT "database.gdb" USER...
http://www.experts-exchange.com/Database/Interbase_Firebird/Q_20522898.html
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
/combat.asp, line 134
theres the error i get, in this patch of code......
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20530291.htm...
Zones:
ASPDate Answered: 02/26/2003 Rating: 7.4 Views: 0
Hello,
Adaptive Sever Enterprise is up and running in linux, but when I tried to connect via isql. It gave me information about unix-odbc.
Thanks for you help.
http://www.experts-exchange.com/Database/Sybase/Q_21260676.html
Zones:
SybaseDate Answered: 02/26/2005 Rating: 7.8 Views: 5
Hello,
I am running MS SQL 2005 and i need to run a script that backs up a database to a *.bak file from the taskscheduler, with MS SQL Server it;'s like this:
isql -S SQL_SERVER -i "C:\Program...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21688384.html
Zones:
MS SQL ServerDate Answered: 01/09/2006 Rating: 9.4 Views: 0
When given no IDE, I have to resort to using ISQL to hit against the database. I have problems viewing the results from select queries and stored procedures because the rows are too wide. This is...
http://www.experts-exchange.com/Database/Sybase/Q_21755768.html
Zones:
SybaseDate Answered: 03/05/2006 Rating: 8.6 Views: 0
'lo perts.
Is it possible to send the output from a isql query to a variable in a shell script?
Example:
isql -b -Usa -P******<<-EOF > $variable
use prod_talis
go
select sum(AMOUNT) fro...
http://www.experts-exchange.com/Programming/System/Linux/Q_21903402.html
Zones:
Linux DevDate Answered: 06/29/2006 Rating: 8.0 Views: 0
Hi
Can anyone give me an example of how to create a .bat file to execute some sql statements to create tables using isql. I am ok with the sql it is the isql I need examples of including the ex...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23100611.html
Zones:
MS SQL ServerDate Answered: 01/22/2008 Rating: 7.8 Views: 0
