Hi,
I want to connect orcle using ODBC without installing oracle client. I don't know how to install ODBC without installing oracle clients.But i have ODBC setup exe(ora8.1.7.exe).In...
Does any one know how I can export the results of an SQL statement straight to a text file through code.
i.e select * from tablename would immediately create a text file in a specified loc...
Hi,
I have an SQL database from our old MSSQL server that is in the format of two files, foo_Data.MDF, and foo_Log.LDF. How can I convert this, WITHOUT RUNNING MSSQL, to another format, su...
When trying to install MSDE I am told that a strong SA password is required and the installation quits... can any one tell me what is the SA password, where do I find it and how do I change it...
What is the maximum size of VARCHAR2(),
Is it 3000?
If yes,
If I create table with VARCHAR2(3000) is it wasting the memory or it will cover only what space I used?
For example,
...
I have a stored procedure that receives 20 different parameters as fully built Insert queries...The potential exists though that some of those parameters may be passed to the stored-procedure ...
hi experts, i have a very big database in .DAT and some like .BAK extension , any idea how to view the database, meanwhile my programmer not very keen to tell us which application to used to o...
Hello,
I have 2 tables, obviously joined on a key.
I want to insert data into 1 table, and then insert multiple values into the second table using the autonumber that was assigned to the...
I have a table with a notes field of varchar(255). I have created a view of the table to convert the varchar to a char field for fixed lenght bcp out. The problem lies in that the notes fiel...
Hi,
I am new to TOAD Oracle. I wrote a simple sp and don't know exactly how to execute, although I have tried right click on my sp name in Object window, and set up an input value.
Basic...
Hi all,
i need help with some sql. I have a table with 200,000 rows of data. one of the columns ref contains non unique values. I'm only interested in these rows if the ref values are not ...
Hi all.
I created a VIEW in SQL Enterprise Manager and was wondering if I could have it accept a parameter for one of the fields(CustomerNumber), I will use this VIEW in an Access report.
...
hello all -
i'm using the ADO.NET Data Provider for SQLite to insert some date / time records. the data is inserting fine, but once it's in my sqlite db, it's not behaving correctly when i...
Hi,
I am using SQL server, and have one table populated, cannot be drop and add it again. How can I change one column (or field) name using SQL statement?
Thanks.
Ok... Should be fairly simple... I just dont know how to do it...
Say I have a varchar(50) column with a record with "Yeah Baby! Yeah!!"
I want to do a select against a value that has no p...
To load data into my oracle db, I use a bat file named load.bat including:
C:\oracle\ora90\BIN\sqlldr xxx/xxx@xxx,control=anotherfile.ctl,log=c:\logfile.log
...
in which xxx are username,p...
As system analysis I am reviewing some stored procedures. In one case I asked the developer to create a selectmatching stored procedure that would get as parameters all fields on the table. ...
Hi,
Can anyone tell me why I am getting the following error message and how to solve it for the SQL code below:
Cannot resolve collation conflict for equal to operation.
As you can ...
Hi,
I used this statement to update one column the 1st table from column value in a 2nd table:
update testb1
set col2=(select col2 from testb2 where testb2.col1=testb1.col1)
But thi...
hi all,
i am using the below query to do a fast export in teradata
sel
CAST((b.id (FORMAT 'zzzzzzzzzzzzv')) AS CHAR(12)),CAST('|' as char(1)),
from
customer b
here the column ...
I have the following stored procedure that runs 2 sql statements, basically the statement are the same except for an additional "AND" clause when @intReg > 0.
Firstly this does not work, I ...
Dear all
I want to insert a french format date "dd/MM/yy" into a MS SQL table, But the fields default format is American "MM/dd/yy"
How I can change this default format.
Regards
George Er...
dear club members
I want to grant "truncate table privileges" to a non owner user.
If any body know please let me know
THanks
I am currently retrieving the date time in one of the text box in a form
Dim checkDate As Date
checkDate = Me.DTTXT
the checkdate is in dd/mm/yyyy hh:mm:ss format. I want to convert i...
I have the following I copied from some where:
BEGIN TRANSACTION
lock table ABC in exclusive mode
.... ....
COMMIT TRANSACTION
But it is not working. It keps saying:
...