• Duplicate Sql

    Hi, I want to know in a given PL/SQL Procedure or PL/SQL Function How to find the duplicate(i.e., Repeated) SQL Statements. regards, aditya.

    Garimella5 pointsBadges:
  • Access databases

    I have a database that is in Access, Does anyone know if it is possible to query this DB using SQL server 2000..?

    Michaelrdowney10 pointsBadges:
  • can a file be loaded from an embedded sql statement?

    can a file be loaded from an embedded sql statement? I want to use the file that was loaded to display the data in a subfile.

    Cansler50 pointsBadges:
  • how to get database name?

    hi i am using th sql statement "SELECT * FROM MASTER..SYSDATABASES" but i want for perticular username and password

    Shwetha20 pointsBadges:
  • SQP file members

    Does SQL on AS400/iSeries allow selecting a specific member to be prcesssed without using a OVRDBF command?

    DMinNC10 pointsBadges:
  • Problems with the SQL query function

    I am designing a website, and Iā€™m having a problem with the SQL query function. My table looks like this: Table Structure Ref_ID Mem_ID 1001 1002 1001 1003 1001 1004 1002 1005 1003 1006 1003 1007 1003 1008 When I try the command ā€œselect * from table where ref_id='1001',ā€ it returns 1002, 1003...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Why sqlcode error=100 comes ?

    sqlcode error=100 comes. The required fields are being populated in table. Still why i am getting this error ?

    NAVIN5 pointsBadges:
  • SQL insert statement

    Hopefully there are some ASP experts put there who can help me. I am trying to write an SQL insert statement to populate an access database from an HTML form. When I submit the form, I am getting page cannot be displayed with the following error message: Error Type: Microsoft VBScript compilation...

    Sturdy2725 pointsBadges:
  • crosstab query

    how to make crosstab in my sql?

    Tafz085 pointsBadges:
  • SQL

    I have some duplicate rows in my SQL database table, Please Tell me how'll delete duplicate

    Badrugts5 pointsBadges:
  • How Do I Fix A Implicit conversion Error

    I got the following error on the first line and I'm not sure why. The appropriate fields in both tables (oas_balance and oas_testit) have the same data-types. Could it be an out of order thing? ERROR: Implicit conversion from data type varchar to money is not allowed. Use the CONVERT function to...

    Ilfoprog50 pointsBadges:
  • free software for measuring disk I/O

    Hi, any recommendations for a free software to: Measure disk I/O & SQL Server statistics from many server at once + make graphs of the data?

    Milkyway5 pointsBadges:
  • How Do I assign a value if a value in the field is empty

    In my script (that is not working yet) I want to make sure if "full_value" (a field) is empty in a particular record then the value zero will be inserted. This is working in Access, but I'm trying to rebuild the query in SQL. Thank you. SELECT DISTINCT oas_balance.cmpcode, oas_balance.el1,...

    Ilfoprog50 pointsBadges:
  • I want to return multiple value in the THEN clause of CASE statement

    I want to return multiple value in the THEN clause of CASE statement. SELECT c.company_code, c.com_inactive_flag, e.emp_no FROM company c, employees e WHERE c.com_code = e.com_code AND e.emp_status in ( (CASE c.com_inactive_flag WHEN 'N' THEN 'A' WHEN 'Y' THEN 'B,C' END) If the flag is N all those...

    Balcode5 pointsBadges:
  • write multiple images from SQL database using response.binarywrite

    It seems I am able to write a single image with the following code: ID1 = replace(request("ID1"), "'", "''") Dim connStr connStr = Application("DSNFPT") Dim rs Set rs = Server.CreateObject("ADODB.Recordset") rs.Open "select [Image],[ContentType] from FPT_Images where ID = " & int(ID1) & " order by...

    Tacopants5 pointsBadges:
  • error in reunnig sql plus

    when runnig sql plus of oracle 9i,after giving puser id and password protocol adapter error is there..iused both id an pw i.e. system and manager or scott/tiger

    Krshah5 pointsBadges:
  • SQL CurDATE

    I need to change the system CURDATE()to CYYMMDD so that I can subtract 2 days to compare to our data. Any suggetions?

    NewGirl5635 pointsBadges:
  • sql

    is it possible in vb.net to read two database(access) with one sql? like select * from databaseA!tableA union select * from databaseB!tableB what connection type to use ty in advance

    Maytel5 pointsBadges:
  • Catching blocks using a stored procedure in SQL

    I have a stored procedure in SQL that I use to catch blocks. This stored procedure is executed by a stored procedure higher up. How do I relay the error info, if there is error info, to the parent? Do I need to use a return code or is the error info just passed back, no matter what?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating shell scripts

    We have to move more than 250 shell scripts from a unix to a linux environment, and also 100 sql scripts. Could you please give me some steps or a check list to follow to migrate these from unix to linux?

    Chunter110 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