• VB 2005-SQL CONNECTIVITY

    HOW DO I UPDATE A FILED IN SQL THROUGH VB 2005?

    N74015 pointsBadges:
  • oracle 9i instalation

    hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal oracle7 I installed and used to do my practice...but now I have heard that you can install 9i on...

    11g5 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:
  • Index Tuning Wizard shows error occurred while executing SQL statement but I can’t find the problem

    I am facing a strange problem while using the Index Tuning Wizard (ITW) in SQL Server 2000. It shows error occurred while executing a SQL statement. I've checked every thing like trace is okay, as they show no problem with SQL Server 2005. Kindly give me some solution, URGENT.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating SRS reports to new data structure

    I'm migrating to a new database with different tables and fields but want to continue to use the SQL SRS reports that I previously had (there are hundreds of them). Is anyone aware of a tool that will allow me to map the new and old data structure and update the rdl files for SRS?

    Nmenjivar5 pointsBadges:
  • Using SQL CLI APIs to call an sql stored procedure on an AS400

    I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) . Thanks Mike

    I5DB2DBA5 pointsBadges:
  • Linking to a table in SQL with Visual Basic

    How could I link to a table in SQL using Visual Basic?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ERP form error message on a SQL database

    We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieving values from a table in SQL

    I have values stored in a table in SQL this order: -99.4%, 99.5%, -99.6%, -99.7%, 99.8%, 99.9% I'd like to retrieve them in this order: -99.4%, -99.6%, -99.7%, 99.5%, 99.8%, 99.9% The ORDER BY clause does not do so. Is there another clause I could use?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Not Return Any Record if Value Exists

    If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id has a...

    Rjwilcox45 pointsBadges:
  • SQL Text Match on Character Stream (wildcards)

    I need to match a text field on zero or more characters. If available, the 'or more' characters need to be in a specific sequence. The % wildcard doesn't quite cut it. For instance, I need to match the name with 'm', 'ma' or 'mar' (but no other character combinations). Is this possible?

    Ohreallyus5 pointsBadges:
  • Designing a report in SQL from an Excel worksheet

    I am trying to design a report from an Excel worksheet, and I’m not sure how to get this information into SQL. I have 180 files with multiple tabs in each that house all the data I need, but I only need one tab from each of the files. Is there an easy way to import this specific information?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Questions about a SQL database with hourly transaction log backups

    We have a SQL database with a full recovery model that backs up the database once a day, along with hourly backups for the transaction logs. However, we only have one transaction log backup file, and it is overwritten every time. Are transaction log backups cumulative, and if so, does that one file...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL DATABASE SERVER

    Hi, Please how can I access a client SQL database server remotely to update date therein. My client have this MS SQL Server Ver. 9.00.2047.00, Product Level: SP1, Edition: Standard Edition. and I will need to update the data. I have to update the database. I have downloaded SQLEXPR and installed in...

    Chukbillo20 pointsBadges:
  • date functions using Oracle

    Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is in...

    Maha15 pointsBadges:
  • to write code

    i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i execute it...

    Daudkhan5 pointsBadges:
  • my question

    How to find the repeating charactar or letter in a string like 'information' in pl/sql or sql .

    Maneswar15 pointsBadges:
  • AR server

    we r using the AR server 7.0 the backend database is sql 2000 under window platform, so now if I need to change the database table format to CLOB then, any one could tell me what is the format of changing the database format, I mean the table format to In-row and Out-row method. Could any one...

    Jiji5 pointsBadges:
  • Maintaining a company table in SQL

    I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at run time...

    SQL Server Ask the Experts2,585 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