• How can I get a list of SQL Server queries that are running?

    Would anyone happen to know if there's a way I can get a list of queries that are currently running on my SQL Server? I noticed that I have a large query that's running on one of my database servers and I have to stop it. Thanks!

    ITKE409,090 pointsBadges:
  • 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...

    ITKE409,090 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...

    azohawk1,865 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.

    ITKE409,090 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?

    ITKE409,090 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...

    ITKE409,090 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!

    ITKE409,090 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...

    ITKE409,090 pointsBadges:
  • PowerBuilder 11 in SQL 2008

    We are seeing performance issues with our PB 11 app after SQL 2005 DB was migrated to SQL 2008. We did not change any code just the connection profile. From: [Profile APP] DBMS = SNC SQL Native Client(OLE DB) Database=database UserId= DatabasePassword= LogPassword= ServerName=SQLServerName LogId=...

    Lstadler5 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:

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