Hello,
This question is for a friend of mine. He owns a small automobile wheel/rim shop. He would like to be able to keep track/have details of all his inventory/sales. Is there software...
Hi EveryOne,
when i try to execute the below code it says,
ORA-00972: identifier is too long
at the lineadapter1.Fill(Ora_Dataset)
CODE:
Sub BindGrid()
sSql= Select * from Audit_Excep...
Has anybody worked with SQL 2000 systems where majority of the SELECT statements had been forced to have WITH (NOLOCK) in them? All statements look like Select * from Table1 WITH (nolock). We ...
How do I insert rows into an Access table. I update a neighborhood directory and sometimes there are more than one last name at the address. I need to insert both people but do not know how ...
Hi,
I want to perform a simple crosstab which will show me how many calls (count) were logged on our system for each hour of the day between a specific date range. I have created a date ra...
Hi All
I have a database and all the files are in .dat format. How do I export them all to .txt format. Arethere any programs that can do that ?
Cheers
Respected Sir,
I want to connect the dataenvironment thorugh oledb/odbc at runtime that the datase having password for the databases ms-access and ms sql server 2000
Hi
I am getting error in my application.I used nhibernate.In my database we have table DVBChannel.it contains foreign key DVBStatusID.DVBStatus table contains DVBStatusId,Description.When i t...
Hello,
I have a subreport with 3 detail sections. Each one of these sections has a label in it where I display "Sunday" if the Time Entry record is on a Sunday.
The problem I'm having i...
General question
1) relink all...how does one check and see if relink all is successfull? or what command to use to see if relink all is successful?
I used tar xvf 9207.tar to extract 9207...
Need to produce a query of all employees that "Report To" a given magager. Multiple "Report-To" levels exist.
Assume this table:
EMPLOYEE_ID INT
EMPLOYEE_NAME VARCHAR
REPORTS_TO...
We're seeing an SQL error on our websites after yesterday's migration from WIN2K Server, SQL2000, IIS5 to a new WIN2003 Server Standard with IIS6, MSSQL Server 2005 .
When we first access...
Box 1= Win 2003 R2
Box 2= SQL 2000 Enterprise Edition
When running ASP scripts (db read/write) on Box 1 to the DB on Box 2, we get the following error:
Microsoft OLE DB Provider for SQL...
I have 50 control files for sql loader to load data from flat to oracle database..how do i run this n one shot in windows environment or using toad??
I'm creating a small application that have two tables, with at most 500 records in one table, and 10000 records in the other table (AT MOST, after years and working!)
I previously used MS SQL...
Hi,
Is there a way to select from a filtered (while selecting) field at the same time? E.g. I have a table named "info" like following. I need to remove all "-X" and left with only the nume...
Hiya,
I'm not sure if this is a question with a straight forward answer or not really..
I have a table "Towns": Town_Id Name
and a table "Areas": Area_Id ...
We're on IBM's UniVerse DB 10.1. I've written programs to update tables in an SQL DB from universe data but now I'm starting to write a table driven version because I need to convert far mo...
Hi,
I want to create a stored procedure which will call another function it..I have everything ready..i am using
Run > db2cmd
CD StoredProceduresFolder
db2 connect to db user 'x' using '...
I have a SQL Server 2000 installation running on a Windows 2003 server. The problem I'm experiencing is that various clients (SQL Query Analyzer as well as various applications) seem to lose ...
Hi all
I'm grappling with a database modelling problem.
Thought this would be better directed at database people rather than programmers, but really it's a software design question.
The...
I am starting a project that manages the information for the school prom and want some advice regarding how to set up the tables correctly. Here's the situation:
I have tblStudents to use a...
I used to have my SQL 2000 database on a celeron based server so we moved the database on a quad core server with a lot more memory than the celeron based server. For some reason the database ...
Hi, Is it possible to use a bind variable to create a table?
something like:
variable table_name varchar2(50)
execute immediate :table_name := 'my_table';
create table :table_name...
We use a CRM product with a Delphi front end and Advantage Database Server (ADS) on the backend.
I want to access a copy of the database, and change some data in the tables (move data from ...
