• SQL 2005 trial version update

    I installed SQL 2005 trial version on a production server and the 6 months are almost up. I would like to go to SQL 2008 since I can get a very good deal for it. What options do I have? Can I just upgrade over the trial version or I need to uninstall 2005 and reinstall 2008. The 2005 is a trial for...

    Alan Dala30 pointsBadges:
  • Prevent Update in DB2 SQL External Trigger Program

    I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a...

    Djswtd25 pointsBadges:
  • Insert superscript text into Oracle database

    how can i insert superscript or subscript text to the data base i have colomn called measuments Units and i want to insert quadratic meter M2 or Cubing meter M3 am using oracle 9i pleeez help

    Rosealzubi115 pointsBadges:
  • Webpage and SQL interaction

    The problem I need to figure out is that I need to have client information stored on an SQL server database and I need something to be able to use this information to get quotes from several insurance companies. All these companies require different info in a different order. So my questions are as...

    Katy20 pointsBadges:
  • Issue SQL Query with Localized String through PowerShell

    Hello, I am attempting to execute a an SQL query through PowerShell against an MS Access database. My query works 99% of the time, but occasionally a localized string will cause an error beacuse it contains a single quote (') somewhere within the localized string. You can look at the following...

    Bgsullivan15 pointsBadges:
  • SQL proceedure to join header and detail file

    I want to know how to set up a SQL procedure that joins a header file and detail file where the status field in header = 'X' then updates this header record after selecting the detail records.

    AS400 - Ask the Expert485 pointsBadges:
  • SQL help

    hiow to pick only alphbets in a string or a column using sql

    Ecsbc35 pointsBadges:
  • I need to display only last two characters

    i need to disply only last two characters in a column, the column data like this 1.3.2NE,1.2.2NN,1.10CE,1.11.1NN,10.3 for this i need output like this NE,NN,CE,NN

    Ecsbc35 pointsBadges:
  • Grouping the records in RPG

    How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

    Shwesmile20 pointsBadges:
  • Return specific level parent

    Can anyone help? I have a table, with 7 records ID ParentID Level ------- ------------- --------------- 01 (empty) 1 A 01 2 BC A 3 X BC 4 B 01 2 DE B 3 Y DE 4 I need a query to return, for every record in the table, the corresponding 'Level 2' ID, excluding records with a Level of 2 or higher (i.e....

    Paulvian5 pointsBadges:
  • Facing a problem while working with transactions

    I m having my SQL server on Machine A and i m starting one transaction on server from Machine B, now in between suppost Transaction from Machine B creates a new record in one of the table on server using insert into statement, after creating the record the LAN connection of Machine B is...

    Rajratna5 pointsBadges:
  • SQL – SQL Data is not clearing

    Generated my sql data and proceed to load data into a subfile. It works great except for one thing every time i leave the program and return back into the program, my subfile is load with my last search criteria and i don't know how to clear the buffers or tempfiles or whatever sql does with its...

    Pablov45 pointsBadges:
  • Timed execute array or function

    Hello there I am new to sql and cold fusion I want to create a timepicker to execute an array of function at x time. whether in sql or coldfusion. Thanks in advance

    Ctc12320 pointsBadges:
  • QMF for Windows

    How can I execute 10 sql at one go ?

    Jams5 pointsBadges:
  • Embedded SQL

    I need to get a grip on using the embedded SQL in an RPG ILE program using the word "CURRENT" and I need to know how this works (in laymens terms please.)

    Chinadoll04149810 pointsBadges:
  • MIgration to 64-bit Sql Server

    What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

    Tomfitzrugger5 pointsBadges:
  • Using answer as criteria in sql server

    I have a table that has a demand order and a supply order I want to search for a order in the demand order column it may have more than one supply order and then I want it to look to see if that/those supply order is in the demand column and if it is get the supply orders and so on. So essentially...

    Jeremyj545 pointsBadges:


    N74015 pointsBadges:
  • SQL Injection Removal

    How can i remove all instances of the following from my database? <script src=http://www.jic2.ru/script.js></script> thanks Bosco

    Bosco32225 pointsBadges:
  • Printing Reports to Dotmatrix Printer from Visual Basic 5.0 OR 6.0

    Respected Sir, In SQL I would like to solve the following complex script by using Visual Basic 5.0 or 6.0 Versions. First Table Name: tblClient Fields: ClientID, ClientName Second Table Name: tblPurchase Fields: ClientID, Item Name, Qty, Price Here How can I pass one SQL query for a Dos print out...

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