• Inserting 50000 rows using FORALL statement

    How can we insert 50000 rows by using FORALL,please give me entire code?

    Ramesh5530 pointsBadges:
  • Problems with VAL function

    I have a table with an NVarChar field that contains left aligned numeric values. I've tried using the VAL function to return the integer values, but I'm getting back Short Date results. What can I do to get integer results? Thanks, Arlin

    Arlin70 pointsBadges:
  • In-Memory Database

    What do you mean by In-Memory Database? Is it like loading of database data along with application? Please explain me how the In-memory database get loaded along with the application.

    Techy001340 pointsBadges:
  • Combo search box – “Invalid Outside Proceedure”

    ..and before you ask, no I don't use anything linked into Access 2007 to program my database. So, I've been creating a form coming from the same table with the same information to be used as a separate edit form. And now suddenly my "search box" gets this error in my normal form. HELP!

    Abaumeister25 pointsBadges:
  • How to move the msdb database to sql 2005

    I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I'm getting a compatability error message. Any suggestions greatly appreciated.

    Bubbanm90 pointsBadges:
  • Unable to import data using DSN file from SQL Server to Microsoft Excel or Access?

    hi ALL, i have a strange situation, there is few people who is not able to load data from sql server using dsn file. I have used correct method, i have used odbc driver -sqlserver... i believe every thing should be fine. I have check the access permission for that user. that is not the issue. when...

    Sagar20005 pointsBadges:
  • A Socket Connection was Attempted to an Unreachable Host

    Hi, i am getting this Ureachable Exception when connecting From Pocket PC Application To Desktop Application through Scoket. But The same is Working with Wondows Form Application.Not Working with PockePC Application. I can't Understand this. Please tell me How to solve This Problem

    5149365 pointsBadges:
  • ESX luns allocated on Symmetrix will not format.

    Recently we allocated Symmetrix space for an ESX cluster. Some of the LUNs format fine but one or two come up with an error message that says "unable to read partition information from this disk." All of the luns were exactly the same capacity. The ESX is currently attached to a Symmetrix array as...

    Emcsanman20 pointsBadges:
  • Database Mirror connection string in sql 2008

    Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate...

    GIG240 pointsBadges:
  • Access 2003 Form fields Sync

    Hello, I am turning to you as a last resort :/ Here is the case, thought it looked simple to me at first... : I have a field which needs to be updated according to another field in a form according to the date in a table: Table contains [KEY, field1, field2] and the form uses to updated a different...

    Arielnavon15 pointsBadges:
  • Auto download a .CSV file from network drive

    to a AS/400 physical file through a cl program? how can I do this?

    UARTJ105 pointsBadges:
  • How to use embedded SQL in a RPG program used as a stored procedure

    When I use embedded SQL in a RPG program and call it from another program it works fine. But, when I try to use the program as a stored procedure it gives me a SQL error. I have worked with stored procedures and understand them, but have not been successful using embedded SQL with them. Any ideas...

    Warykat20 pointsBadges:
  • protect sybase DB on centos server

    I would like to know if there is an anitivirus prog that will scan automatically on sybase DB's. Our server allows staff to upload word doc's into the DB,,, with the increase of virus's occuring on out windows PC's,,, i would like to add protection to the doc's in the DB. Any ideas?

    Detox5 pointsBadges:
  • How do i have access fill in a field in the form in opening with data from the parent form

    My first question please feel free to point out to me if i need to do any of this differently I am looking to create a button that opens an existing form with a new record and inserts into a field in the new record data from the parent form. We have a system where information is distributed to our...

    Mandolorean5 pointsBadges:
  • How Do I release unused space from a tablespace after dropping a blob table

    I have a 30 GB BLOB table in a 162 GB tablespace. After I used the online table reorg to move this BLOB table and its BLOB index to another tablespace, Toad tells me that I have about 35 GB free. However, I can not reduce the size of this tablespace (i.e, resize the datafiles associated with this...

    Hmhora10 pointsBadges:
  • redord retrieval in SQLRPG

    Hi, can anybody tell me how to retrieve a record randomly using cursors...(say 8th record) using SQLRPG(Embedded sql)

    ten20081,150 pointsBadges:
  • To retrieve records from SQL Server database

    Hello All, I have a requirement with sql server. Please find below the same. In database say we have a column named "Name" in a table. The records that are available in the table are say like Column_Name = Names Lean Metric Sequence Lean Operation Metric Lean Cleaning and so on.... Now, through...

    Pichha5 pointsBadges:
  • Access 2007 Report OutputTo Print

    Please help. This is driving me around the bend. I have a report that I OutputTo Rich Text format but my Percentage calculations do not survive the conversion from the report to the saved document. Please see: Has anyone encountered this before? I have many other reports and they all save correctly...

    Riaane65 pointsBadges:
  • ASP.NET and Multiple Access Databases Open

    Dear Colleagues Please could you help me? Is it possible to have an ASP .Net Web application with multiple (7) large MS Access 2000 databases open simultaneously. When I heard this I was surprised because there could be dozens of users each using up to 7 large and disparate Access databases...

    Hessm0035 pointsBadges:
  • PL/SQL – Attribute to test not null and can take specific value instead

    Hi Experts, How can we make a check on an attribute not null but can take - rather I have address 3 which can't take null instead - would be fine how this can be check n PL/SQL procedure

    Inprise610 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