• How do i replace a sql tables field value with another value

    I have the following script that works in Access but not in sql. I trying to replace the the value in the field "RSAMSTORE" with another value I give it (i.e. 999994, etc.) when the data is displayed. In otherwords when the select distinct is ran instead of seeing the value in the table "RSAMSTORE"...

    Ilfoprog50 pointsBadges:
  • Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it

    Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it? Hey i have Zip file which i want to extract using the sql script or using DTS Packages. and also want to run the Batch file from DTS Packge. its possible or not ? and yes then how ?

    21748165 pointsBadges:
  • Restrict a script to reduce SQL injection attacks

    I want to reduce SQL injection attacks. How can I restrict a script to execute one query at a time?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Insert records between records in a file using RPG code.

    Is there a way to insert a record in between records in a file? For example, a file contains 10 records (1 to 10). I want to insert a record in between records 1 and 2, thus record 2 will move to position 3, 3 to 4, and so on and so forth. Can SQL/Insert function be used to do this?

    Francissamonte15 pointsBadges:
  • sql scripts

    Hi all, i'm updating a new 'commun management' software n i wanna update the database bcoz i added many extra tables. i did write scripts for all the tables this way: Create........... Drop........... Alter........ so our clients would be able to have access to it. but i have been asked to write...

    JARON5 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