It seems that office 2007 (excel 2007) can no longer save files to dbase. I had been using this facility to create the field headers for dbase files. Can you suggest some workarounds? A utilit...
Hi,
I have an Oracle 9i server. I want to change the "system" password for the same and I am not aware of the old password.
Please suggest how I can do the same.
Regards,
How can I limit a select statement to x numbers of
rows returned. If this was Oracle I could say
select * from my_table where ROWNUM < 50
to get the first 49 rows. I want to do the same
thing ...
Tried to deploy report to page on website and got the following error.
TITLE: Microsoft Semantic Model Designer
------------------------------
A connection could not be made to the ...
I,
I have written this simple SP to pass one value to the SP and return three values.
The procedure is as below:
create or replace procedure get_count_of_dnis1
(
dnis_in_out in out varc...
Hello,
I need to insert miliiseconds in a date field in oracle 9i . I use the following query
UPDATE MSGDB SET CUSTOM25=to_date('2003111212110000','YYYYMMDDHHMISSSS') WHERE MSGDB_ID = 2...
We have 2 databases. A live database that we copy every so often and restore into a test database. Every time we restore the database onto the test database (on a different server) a couple ...
ONCE I ASKED THE SAME QUESTION
DEAR EXPERT..I WAS OVER CONFIDENT AND ACCEPTED
PLEASE HELP ME I AM IN WORK PLACE
I WOULD APPRECIATE THAT.
MY NEW LISTENER.ORA IS
# listener.ora Netw...
Is there a built in oracle function that will give the number of days since a certain (built in oracle) date? eg given 01/01/2000 it would return a number representing the number of days since...
What is the difference between oracle clause "Exists" and "in "
I am trying to do an update query in SQL 2k that updates a name field and removes only the pattern of space middle initial space. I do not want it to strip out any additional names in the fiel...
Here is the script I used in the SQL Server:
-- constants --
DECLARE @sColumn nvarchar(64) -- name of the added column
DECLARE @sTable nvarchar(64) -- name of the table
Set @sColumn = ...
Hi experts,
Can you please look into following query :
SELECT
BA.*
FROM
tblBookingAction BA INNER JOIN tblBookingTask BT ON BA.BookingTaskID = BT.bookingTaskID
INNER JOI...
I have 4 machines in our boxing warehouse, they use FEDEX Ship software and an ODBC to connect to our database. I set up all the ODBC the same but one machine (no different then the rest) is ...
Hello everyone.
I'm a newbie here...so go easy on me. I have the following code in a .cmd file ( sdv.cmd ). I run it from a command prompt like this c:\sdv.cmd >h:\projects\sdv.txt. It r...
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 have a query table in Access 2003 (Table1). The first column has duplicate data. I want to remove the duplicate rows from the table (and keep one row only for the duplicate data). What ...
Hi,
Can Explain what is below mode:
Lock_mode is one of:
ROW SHARE
ROW EXCLUSIVE
SHARE UPDATE
SHARE
SHARE ROW EXCLUSIVE
EXCLUSIVE.
Regards
GT
This works:
SET @X = Case @Y
WHEN 1 THEN 444
WHEN 2 THEN 555
END
How can I make this work:
Case @Y
WHEN 1 THEN
SET @X = 444
SET @Z ...
Is there a function that pad leading zeros in activex?
I have a problem in a client application which began occurring after an Oracle database installed Oracle 8.1.7. Once the software installation has completed, to configure the Oracle Net8 clie...
Hi,
I need to import a text file (fixed-length) into the table.
I have created a DTS package to automate the process, but now i want to do it programmatically from the web application.
...
Is the Query Analyzer tool only available with Enterprise Manager? I'm wondering if there are other ways to obtain it (MSDE, VS.Net, etc.) Thanks!
Good morning! I have what I hope is an easy question for many of you experts.
When executing this query, I get the error: you tried to execute a query that does not include the specified ...
HI,
At present my SQL Server table has the following field as the Primary Key: mst_rec_nm
I would like a SQL script to re-assign the Primary Key to this field: rtns_prm_key
thanks a lot...
