• How do I run and import a large .SQL file?

    I've been using RedGate Software for SQL data comparisons and it turns the data into a .SQL file (this is for running on another machine). Here's my issue: It's a pretty large file so copying and pasting won't work and when I try to open it in SSMS, I always get the error message that it's too...

    ITKE436,030 pointsBadges:
  • SQL: In responsiblity wise last 5 transactions details request as on 31.03.2016

    AS per audit review request: All responsibility wise  AP, AR, GL, CM , FA , PO, Inv last 5 transactions taken from the sql as given date for 31.03.2016.  Please help on our request.

    Thillainathan5 pointsBadges:
  • What is requirement coverage and how it can be achieved in QC9.0?

    Actually I'm trying to analyze the requirement coverage by linking requirement with the test case but it is not showing how many test case is been failed or passed it is showing only in terms of the requirement is passed or failed.

    preethikiran5 pointsBadges:
  • Should Agile requirements be independent or dependent?

    Should Agile requirements be independent of other requirements or can they be dependent on other requirements? I assume independent so they can be worked on individually.

    blamaute5 pointsBadges:
  • SQL: Avg function for calculating the age of a man and woman in different columns

    I would like to use avg function for calculating the age of a man and woman in different columns but as a total in each case. Could you help me" For instance, Select Sum(case when woman then '1' else '0')woman Sum(case when men then '1' else '0')men Avg(birthday woman)avg1 Avg(birthday men)avg2

    pe444000hhhhh5 pointsBadges:
  • Using EPP port with Delphi

    How can I use the port for I/O using Delphi. I am not clued up with Windows API, but I need the app to be a single EXE file without any installations or separate DLL's. Many thanks. John

    psefix5 pointsBadges:
  • Which type of websites easily develop with WordPress CMS?

    Please given information about Wordpress CMS. How it can help in web design and development?

    hirewpdevelopers130 pointsBadges:
  • Where can I start my SAP career?

    I would like to change my track & want to get into in an IT industry. I don't have any computer or Engineering background. So please guide me, will a SAP Course will be helpful for me? Is it correct to do that? I am a Commerce post graduate student and had work experience in Back office...

    Prachikul5 pointsBadges:
  • Doubt in access specifiers

    If I use public void buublesort(int[]arr], I'm not getting output. Overall program, I'm using integer values. Now, if I use string []args means I'll get error. How to handle this type?

    kanasu5 pointsBadges:
  • VB6 with Oracle 10g as database: Using add, edit, delete and search button with following fields: title, author, publisher, year, category

    How can I set up a library system with add, edit delete, search button  with following fields: title, author, publisher, year, category using VB6 and Oracle as database? Thanks

    jeremy275 pointsBadges:
  • SQL (QMQUERY) date conversion issue

    I inherited a QMQUERY program that my user came to me today indicating that the week number was not correct. This query puts data into a workfile and a second query is called that splits other data into fields. As far as the two relevant fields are concerned, the second program does not modify...

    azohawk2,020 pointsBadges:
  • Create ER diagram in Oracle SQL Developer

    I'm fairly new to Oracle SQL Developer and I'm trying to create an ER diagram for my database tables. How can I go about this process? Any help would be appreciated.

    ITKE436,030 pointsBadges:
  • SQL average command for column IDs

    For SQL, does anyone happen to know if I can use the SQL avg() function for average by my column IDs? Basically, I have several different IDs and I'm trying to get the average of each through one query. How can I go about this?

    ITKE436,030 pointsBadges:
  • How to SQL update several records in a query

    In SQL Server, I have a table that's labeled this: config_name | config_value. I'm looking to update several records in one query. Here's what I have so far: UPDATE config SET t1.config_value = 'value' , t2.config_value = 'value2' WHERE t1.config_name = 'name1' AND t2.config_name = 'name2'; But...

    ITKE436,030 pointsBadges:
  • How can I stop the export process in SQL Developer

    I apologize in advance if this is a stupid question but does anyone know how to stop the export process in SQL Developer? Thanks!

    ITKE436,030 pointsBadges:
  • Will Visual Basic 6 still work under Windows 10?

    I retired 15 years ago, and write VB 6 programs for my own use to keep occupied. Will Windows 10 mean "forget it or learn C#"?

    jAubel5 pointsBadges:
  • Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE436,030 pointsBadges:
  • Visual Basic Battleship game complications

    Hello! I am creating a battleship game on visual basic for my computer programming 2 final. In order to chose where you want to place the ship, I allow the user to click on a picturebox of the ship and it brings up another form that has the battleship grid with a checkbox on each square. I realize...

    HelpMeWithThisPlease5 pointsBadges:
  • Create first database in Oracle Database 11g Express

    Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I...

    ITKE436,030 pointsBadges:
  • Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 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.

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

Following