• DB2 Logical Files – Select/Omit statement

    Is it possible to use field-to-field comparisons in a select/omit statement or must the comparison be a literal?

    DoctorT15 pointsBadges:
  • How can we migrate Oracle database to Microsoft Access?

    oracle to ms access

    Vsrameshkumar025 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend5 pointsBadges:
  • AS/400 – DB2/400 PF and LF have different identifiers for Synon

    Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

    As400pgmmer305 pointsBadges:
  • AS/400, RPG, ILE, DB2/400

    Hi Group, Please let me know.... How to analyze the DUMP of RPG in AS/400? What are the steps involved? Thanks & Regards, M

    mvrkrishna555 pointsBadges:
  • Advantages and disadvantages of clustered indexes

    What are the advantages and disadvantages of clustered indexes?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • How to run a stored procedure directly from a begin- end; statement?

    I have a stored procedure with some dbms_output statements in it , i want to run this stored produre directly from begin end; statement in order to check how it woks...

    hussain22juzer500 pointsBadges:
  • Connection between VB forms and MS access DB

    I need a code for connecting multiple VB forms and MS access databases.

    Tlapeng50 pointsBadges:
  • How to make installer of VB.NET including SQL Server 2000?

    I had done my project in vb.net with sql server 2000 but it's installer doesn't work properly as it displays the message unexcepted error while connecting to the database.I know setup and deployment in vb.net but doesn't working please help me.I am stuck in here.thanks in advance.

    Rebi97745 pointsBadges:
  • Problem inserting data using OPENROWSET in SQL Server 2000

    When I insert data into a table using OPENROWSET in SQL Server 2000, the data in the table comes up as “2.00804e+007” and “6.02303e+007”. Why might this be?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Errors creating database with SQL Server 2008 I&M Training Manual

    I'm going through the SQL Server 2008 I&M self-paced training manual, and when I do the exercise for creating a database, here's what happens: CREATE DATABASE TK432 ON PRIMARY ( NAME = N'TK432_Data', FILENAME = N'c:\test\TK432.mdf', SIZE = 8MB, MAXSIZE = UNLIMITED, FILEGROWTH = 16MB ),...

    Howhighthemoon20 pointsBadges:
  • rtf text in SQl Server

    We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access - Word strips out the rtf tags and returns a...

    EricF5 pointsBadges:
  • Optimizing a SQL Server stored procedure

    I want to optimize my stored procedure in SQL Server, as it takes some time to execute. It uses a temporary table to store some data, and then it uses a dynamic query that we execute using the EXEC statement. How can I remove temporary table or, in general, how can i improve performance of this...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server trigger, insert result of multiple where clause into a variable

    Hi All, I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one? For example (Working one) SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value) But I am...

    Jacquesvdm20 pointsBadges:
  • Script to restore database permissions during a migration to SQL Server 2005

    We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ODBC connection to the SQL server from the iSeries

    Is there a way on the iSeries to establish an ODBC connection to the SQL server?

    a1maida150 pointsBadges:
  • How to connect my application using Visual Studio 2005 to a SQL Server database?

    how to connect my application using visual studio 2005 to a database using sql server?

    MissVeryLittleKnowledge5 pointsBadges:
  • Hardware requirements for SQL Server 2005

    Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db 's will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the CPU's, RAM memory and...

    Arne5 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