OS - Windows XP Pro SP2
MSDE Client in Question - SP3
Scenario:
When attempting to install MSDE, I receive the error "Setup has failed to configure your server. Refer to the server erro...
hello experts,
Please tell me how to get the output of 2 lines in same line using pl/sql's dbms.output.
by default it gives next outupt in next line.
waiting..
Thanks.
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 ...
Hi,
I have to compare two strings using Oracle SQL to see if they are similar.
For example, the title of a song in one table might be 'White and Nerdy', in another 'WHITE AND NERDY' or 'W...
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 just installed Oracle Enterprise Edition, i tried to run SQL Plus. I requested username and password. I googled and by chance i found username should be scott and password is tiger whic...
Is it possible to check if an index exists? if so - how?
Thanks
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...
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!
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...
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...
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...
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 = ...
The result is same sometime but what is the key diffrence betweem 2?
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 ...
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...
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 ...
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 ...
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 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...
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...
Is there any reason why or why not you should do an 'order by' in a subquery? Performance increase if you do? Output is the same either way, right?
Hi all,
Hopefully this is a straightforward question.
I need to execute "DBCC CHECKDB" on my database, but to do so, I must be in single-user mode.
I know how to start the database in...
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 ...
I have two tables "Contracts" and "BinNumbers" . Table "BinNumbers" contains one field "BinNumbers" There are 20 records with numbers 1-20. Table "Contracts" contains 2 fields "Status...
