Hi,
I wanted to know the major differences between MySQL and ORACLE.
Thanks in advance
Hi,
I'm confused about differences or results in the following 2 queries. One returns the desired results, the other does not The logic that I am trying to accomplish is that I want a lis...
Hi There,
I had asked a question related to something like this before but never got to the bottom of it. I am hoping someone can help me this time.
I have a text field with in this field...
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 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!
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,
I am having trouble getting the top 10 rows in Teradata.
This is been complicated by a couple things:
1. I don't have permissions to create a temporary table.
2. I am using a group by ...
I am trying to find a way to add some numbers to a column of data in MS SQL 2005. I am not sure if this is possible in MS SQL, but below is what I am trying to do -
UPDATE Table
SET colu...
Could you assist with E-R Diagram given the followinginformation
A care center each care center is identified by an id code and a name
items is anything that is used to care for a patie...
I have the following query:
select a.file_job, Cntr=count(cont_num), CntrOut=count(date_out), CntrIn=count(date_in), Status=''
from cargodetailcontainer a join cargodetail b on a.file_jo...
Hi All,
Its silly, but your input is apriciated:
I need to update field 'CallerNumber' where is NULL in database to become 011666666
Please correct the following query:
update dbo.Tabl...
I try to connect to a db with the Enterprise manager and I get this :
SQL Server does not exist or access denied ConnectionOpen (Connect())
I get this message with every connection I tr...
Someone completely deleted my SQL Server 7 database. I retrieved the .LDF and .MDF files from a network backup. Now I am trying to attach the database. I have tried this without creating an...
I have a table which looks like this (comma delimited):
"ID","Name","Expertise"
The "Expertise" column contains data that is semi-colon delimited (e.g. Apples;Bananas;Coconuts)
I want...
Is it possible to check if an index exists? if so - how?
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 ...
Experts,
Currenlty all DB in my company is on SQL Server 2000 and we plan to build another DB server with SQL Server 2005 to take the place.
I am wondering what is the best way to perfo...
Hello,
Trying to return the rightmost 5 characters in a multi-length field (1-9 characters). In Excel or VB I could use the RIGHT function to get what I want, but I'm using Discoverer which ...
In ODBC Administrator, when I try to configure an existing data source that is using the Microsoft Access Driver, I get the following message:
"The setup routines for the Microsoft Access D...
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,
Please kindly assist how can we have a nested case statement.
i.e.
select case when Col > 1 then 'Greater' else case Col =2 then 'Equal' else 'Less' end
Thanks.
PostgreSQL question...
I want something like this:
CASE WHEN EXISTS(SELECT constraint_name FROM information_schema.table_constraints WHERE constraint_name = 'FK_ProductPurchased_Customer')...
I have a table structure like this:
idClient DateBuy Price
1 2005/09/01 150
2 2005/08/01 200
3 2005/06/01 300
1 2005/07/01 200
2 2005/06/01 1000
3 2005/05/01 450
I'm trying to do ...
I have a stored procedure (listed at bottom in full) that I am trying to add an IF statement to to allow the code to call the stored procedure to either 'select top x' rows or select all rows ...
Scenerio, I have 100 records. From the stored proc (SQL 2000), I want to pull 10 records at a time in a date order. I want to mark these records so they are not pulled a second time. Th...
