Hello, I'm a total SQL beginner, learning fast but needing some help with a report I'm creating.
The report is for a job ledger and the SQL table includes JobNo, Date, CostCode, TotalCost a...
hi,
plz help me...i have an access database where the date i c is in format dd mm yy hh:nn:ss AM/PM format but when i print it on the webpage(using javascript) it shows in military time..pl...
Computer A is contains main database file. Computers B, C, D, have shortcuts on their desktop to this file set-up through the network. I have also done this using drive mapping(with the same ...
Can anyone tell me why the following works:
SELECT m.value||'\'||'ORA'||ltrim(to_char(p.spid,'00000'))||'.trc'
FROM v$session s, v$process p, v$instance i, v$parameter m
WHERE m.name = '...
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...
This error is very confusing. I wouldn't be surprised if someone can not answer this question. I am offering 500 points.
The problem is with the Informix ODBC Driver. We use Informix ODBC D...
I need to insert a text file from a web site using ASP.NET into a MSSQL 2005 table. The problem is that the website is on a shared host, and they will not give Bulk Insert Permission. Any sugg...
The sql sever 2000 stopped unexpectly yeserday around 9pm,
**********************************
2005-04-09 21:00:19.02 spid3 SQL Server is terminating due to 'stop' request from Service...
Hi
I have an Access 2002 Database file that I'm trying to access from both a Visual Basic 6 project and an ASP page (running on Windows XP IIS 5.1).
The VB6 connection string is as follo...
I have the following PL/SQL code which I am trying to test by copying and pasting it next to the SQL prompt. I want to obtain all the distinct termcodes from three years up to the value in end...
I have an Access database created in Access 2002 and we did a mail merge. We installed Office 2007 today and converted the DB to 2007 and get the following error when attempting to do the mai...
I was given an some old .wdb files to open that I believe are from Works for Windows 4. All I have is MSOffice with Access and Excel and Corel WordPerfect Suite with Quattro Pro. I can't get...
any one have mscomctl2.ocx or mscomct32.ocx, thanks
How to alter my sequence so that last value of sequence should be one more than the max value value of primary key cloumn of the table.
It seems i need to have a procedure which will alter al...
Good day
Can u please assist with the ffg:
I have a table that stores data in columns
adhoc eg
DATE NAME MARK1 MARK2 MARK3 MARK4 ........ MARK24
AUG R...
Hi Team,
I have a question regarding indexes.
Why do we required to drop index on prodcution database and recreate it again. I have seen somany times, guys are talking about droping in...
Hi,
I am using Access 2000 and have two tables as part of my query:
tbl_AtxMaxRow - containing columns TableName (text), RowCount(number), UpdateRowCount(number)
tbl_AtxBatch - containing...
I have a table in SQL that holds a list of values
COL 1
ROW 1 AAAAA BBBBBB CCCCCC DDDDDD
ROW 2 EEEEEE FFFFFF GGGG HHHHHHHH
ROW 3 JJJJJJJ KKKKK ...
Hi Experts,
how to Create scripts with sql 2005 to create table and fields and also to add fields to existing tables .
Regards.
I am using Ms Access database, I have a query which gets the month and year of the date. to do so I use
Format([Date],"mm") AS [Month], Format([Date],"yyyy") AS [Year]
where date is the da...
I loaded the incorrect version of ODBC drives when attempting to re-install lost application. I installed version 2.573.9001.00 of "Microsoft for Oracle". I later discovered that I need to ins...
Hi,
I am trying to use the dbms_lock.sleep comman in a procedure like this for example :
create or replace procedure testing as
begin
dbms_output.put_line('we gonna go to sle...
I need to write a recursive query with the following conditions...I have a table called 'contracts' that can have 1 to may possible sales people attributed to it...each salesperson belongs to ...
Any ideas how to get this fixed--urgent
Event ID: 17052
Error: 9002
Severity: 17
State: 2
The log file for database ' ' is full. Back up the transaction log for the database to free up ...
I am writing a program in Pro*C with embedded SQL commands. My program inputs data from a tab delimited text file, copies the values into the Pro*C variables and then inserts the values into a...
