• Change data page in the memory for MS SQL UPDATE

    How can I change the data page in the memory is written to LOG FILE in the disk?

    sisaygebre2910 pointsBadges:
  • SQL database page level corruption

    Hello Experts, We are facing page level corruption in SQL database. The database size is 650 GB. What should we do?

    DBAPriya30 pointsBadges:
  • Starting a career as SQL database developer

    I recently have finished my btech 3rd yr via cse. I am quite interested in SQL so I want to be a SQL database developer. So please guide me in what other languages I should learn and what other skills I should learn too.

    Rajiv62535 pointsBadges:
  • Error in compiling embedded SQLRPGLE in full free format

    Hi everyone - here's a question from a user in regards to SQLRPGLE: I have written some simple embedded SQL PGMS in COBOL in AS/400, compiled and run successfully. But I am not able to do so in full free format RPGLE. Here is the RPGLE code that doesn't compile. dcl-s sql_RCONAME char(20) ; exec...

    Michael Tidmarsh64,830 pointsBadges:
  • Looping using READ vs Embedded SQL

    Which approach is better? What all the parameters, we need to consider to come to a proper conclusion? Which approach is better in which scenario? Can anyone explain in detail?

    xselvam15 pointsBadges:
  • SQL function value is null

    We needed a change recently as more shipments going international. I needed to make changes to our function to return the new motor prefixes. The old worked fine as if it was not US or CA we used XX to show international. We had just the three country values. Now each country has it's own code and...

    ITKE1,086,875 pointsBadges:
  • Need help on Oracle SQL formulation

    I have a requirement where data is as below: ID            Date                 Comments 101         23/Jun/2018      RR: Insufficient resource 101         23/Jun/2018      Next week apply for leave 102         22/Jun/2018      NULL 103       ...

    shr12345 pointsBadges:
  • SQL: Sum of max of each column

    How can I do sum of max of each column in SQL?Column 1 column 2 2 3 10 4 16 5Should return:Column1 column2 column3 2 3 21 10 4 21 16 5 21

    kakkardeepti995 pointsBadges:
  • AS/400 physical file

    Pf 1 file contain records below: Roll No Subject Marks 1           S1         100 2           S2          80 1           S1          60 2           S2          70 Another file PF2 Contain records below, Roll No Marks 1           180 2         ...

    vivekntt21450 pointsBadges:
  • How to run this SQL

    Display Product Id (obtained by replacing ‘PR’ into ‘Product ’ of ProductId), Product Name (obtained from product name in uppercase format), MaterialName, and Average Product Purchased (obtained from average quantity of product purchased) for product which price is more than 20000 and...

    agung31095 pointsBadges:
  • Case When Statement resulting in number values

    How to write my CASE WHEN statement to result in number values? I am using for example WHEN "PUMPS' THEN '.50'' ELSE 'N/A' END. However the .5 value is in text form and I need that to be in number form.

    nquinonez5 pointsBadges:
  • Could You Prevent SQL Injection In 1 second?

    Does everybody now how to prevent SQL injection in 1 second or auto disable SQL injection to improve security? Thank you!

    akuadauntukmu25 pointsBadges:
  • VB.NET applications with database to web applications

    I have a VB.NET applications with SQL database and I would like to convert or migrate to web Applications. Any help or advise?

    jaakinyemi5 pointsBadges:
  • Run list of queries in particular library using SQL on AS/400

    I want to know how to run a list of queries in a particular library using SQL on the AS/400. Is that possible?

    ORLANDODUBLIN15 pointsBadges:
  • OVRDBF on iSeries used in a CL program

    I am using an SQL statement to insert into a file. I am doing some sub-stringing on a record then inserting into another file. I am getting a LVLCHK error on the output file. How can I use OVRDBF in my CL to insert to my output file? My file PROFILE has the data and PROFILE2 is my output file and...

    Rrbond07655 pointsBadges:
  • Select statement stopped listing records

    The statement is only selecting syntax and not listing records. Process parameter is *RUN. It was working earlier.

    gamurtuza35 pointsBadges:
  • How to get local time of a SQL server?

    Hwo to get local time of a SQL server and store it in a variable of a client program written in C#?

    Edchu5 pointsBadges:
  • How to run queries from SEQUEL ViewPoint

    How can I run queries from SEQUEL ViewPoint?

    tonycurtis405 pointsBadges:
  • Create an Entity Relationship Diagram for a working database (SQL developer)?

    How can I create an Entity Relationship Diagram for a working database (SQL Developer)?

    sonali00725 pointsBadges:
  • Execution plan cost checking in SQL Server 2012

    How can I analyze SQL Server Execution plan in that cost percentage (need more clarification for physical operation, logical operation, CPU cost)?

    kowshi5 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