• Lotus notes to Sql

    I have text files as attachments to emails in Notes Database and I would like to get the information from the attachment and store it in Sql database. Could any one suggest the best possible way to accomplish this I have set of data in the text file It goes like this // Name: Tom // Age:22 //...

    Nanacy0 pointsBadges:
  • programming using c#,winforms and visual studio.

    i cant think of what to write in this part of the code so that the password character is " * " when the user enters his/her password.pliz help private void txtPassword_TextChanged(object sender, EventArgs e) { char Password =GetStyle ("*"); txtPassword.Focus(); } i just have no idea what...

    Drsingh0 pointsBadges:
  • Where is the best site to learn SQL?

    Where is the best site(s) to learn SQL? A place with example coding etc...

    JHAMLW5 pointsBadges:
  • Save and Read a text file from oracle database

    Hi, I want to save a text file into oracle database (i.e. relational table) and also read it from relational table. Can you please tell me the best approach to do this. Thanks

    DeepaBajaj10 pointsBadges:
  • Migration Problem

    I am migrating an Oracle 9i database to a new Oracle 9i database. My problem is that migration of two tables is taking very long. one takes 8 hours and the other takes 4 hours. The reason i can think of is that these two table have clob fields which are being migrated as varchar2 in the new schems....

    Newkipper0 pointsBadges:
  • Updating a table with sub query

    Hi, I need to update a table with a sub query. Here are the steps I'm following but I'm struggling to successfully update the table. the performance of this update has to be good because of the number of rows I'll be updating in production. any ideas? thanks in advance. drop table dummy_test create...

    Fitzdp0 pointsBadges:
  • Subquery as a table reference

    I use Showcase Strategy to develop queries and reports on the AS400. Showcase is telling me that I can't use a subquery to create a table reference to join with in the FROM clause. The Showcase Tech says subqueries are only allowed in WHERE clause. Non-AS400 SQL texts I have read suggest subquery...

    JohnDonnelly0 pointsBadges:
  • Using Local Variable as FILENAME in CREATE DATABASE Statement

    I am trying to use this statement in SQL Server 2000 :- CREATE DATABASE [Maintenance] ON (NAME = N'Maintenance', FILENAME = @TableName , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Maintenance_log', FILENAME = @LogFileName , SIZE = 1, FILEGROWTH = 10%) COLLATE Latin1_General_CI_AS GO The...

    TheHutt0 pointsBadges:
  • SQL behaves differently in two identical Oracle 10g db’s

    I have a SQL statement that is behaving differently in two "equal" databases (equal in schema, but size differs by about 50%). Here's the statement: select distinct 99, 31, b.school_id, a.provider_id, a.student_id, '2007', lpad('01',2,'0'), '0' from studprovider a, student b, school c where...

    Sprevost5 pointsBadges:
  • Use Dynamic Create Table Command in Stored procedure

    Does any one know how to pass a library and table name variable to the SQL CREATE TABLE Command? I need to be able to build the tables on the fly and the name needs to be different each time the table is created. I am calling the SQL Command from within a Stored Procedure. Thanks

    FCARPENTER200 pointsBadges:
  • media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • Call a stored procedure with output parameters

    Good Morning, I have created an oracle stored procedure which has 2 input parameters of type date and 1 output parameter of type PL/SQL table. I recieve errors when I try to execute the stored procedure in SQL*Plus. The stored procedure exists in a package and the Oracle database version is 10g. I...

    IYAN230 pointsBadges:
  • ASP .NET SQL Statement

    Thanks to SheldonLinker my earlier question has been answered. I continue to have 1 issuse and it is with my conditional SQL statement. I'm thinking someone will be able to correct this very easily. Here's the statement: If ("SELECT DataID FROM table1") = UserID Then Update Else Insert End If I...

    Wolfman240 pointsBadges:
  • Updating one record with a field of another record where two other fields match

    I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG...

    Donnewbee0 pointsBadges:
  • SQL – IF Exists Update Else Insert

    I have searched far and wide but have not been able to solve this problem. I am still in the early learning stage and this is the most complex issue I've come across so far. I have a form that when submitted needs to either update fields in a table or insert new records. I originally created a form...

    Wolfman240 pointsBadges:
  • Lotus Domino Database Structure

    Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler

    Mirkia0 pointsBadges:
  • Correlated Subquery – NOT EXIST

    Hi - I'm trying to add a not exist subquery in my where statement and have several other joins ahead of it. I'm having difficulty determining where to put the NOT EXIST as the subquery is named as a column - ie blue.color in (select * from .....). Where would I put the NOT EXIST In this case?...

    Holl1230 pointsBadges:
  • Help on SQL Expression

    Hi, I'm new to the SQL environment and writing expressions and need some assistance or recommendations. Any help or assistance would be greatly appreciated! We have SQL 2000 HRIS system. We are implementing employees PTO plans. Rules: Hired in the month of 7,8 or 9, PTO earned is 120 hours Hired in...

    Number40 pointsBadges:
  • how to interconnect sql server with remote oracle server

    I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.

    Saahil0 pointsBadges:
  • SQL 2005 Restore

    Hello, Yesterday at 1400 I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can't take this long. Does anyone know what I can do??? I need to get this database back up, even if it is the version before the restore. Any help ASAP...

    Sawtooths0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following