• 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:
  • inserting

    from front end we will get 20 records at a time.how can we insert them into a table .

    Sarvasumanth5 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:
  • Access database management

    Hi guys I am managing a database and need to know if there is away of moving 'completed' records into another database but keep them linked. Senario is: We have records of pieces of work coming into the office and which take about amonth to complete the cycle. My query is instead of having this...

    Timanderson5 pointsBadges:
  • processing biometric data

    can biometric data be incorporated into desktop or stand-alone applications like ms excel and ms access?

    Benibo15 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:
  • Microsoft Access export to Excel changes values

    I have a table populated through a form using lookup tables. When this table is exported using "right click,export" to excel or dbase, the values appears increased by 1. For example 0 appears as 1, 1 as 2. When just copy and paste, it does not happens

    Lsegura12125 pointsBadges:
  • Overlapping data on a merge replication between three SQL Servers

    We have a merge replication between our three SQL servers at three different locations. One is the publisher and two are subscribers, and we have a primary key on a table (a unique field with is auto-incremental by one). On the publisher’s server, if the user creates a new order, the table...

    SQL Server Ask the Experts2,585 pointsBadges:
  • crosstab query

    how to make crosstab in my sql?

    Tafz085 pointsBadges:
  • is there anything in SharePoint that we could use to exchange data or hook into Visual Source Safe 6.0?

    VSS and SharePoint 2007: From what I understand, Team Server 2008 uses the SharePoint platform. Our team has already committed to making a WSS 3.0 SharePoint website and will not be investing in Team Server. I am wondering - is there anything in SharePoint that we could use to exchange data or hook...

    ITKE344,705 pointsBadges:
  • Reindex DBF file from Ms-SQL 2000

    Is it possible to reindex an extenal dbf file via linked server ?

    Mic15 pointsBadges:
  • Does a 802.11n access point or router offer an expanded range to 802.11g devices?

    Does a 802.11n access point or router offer an expanded range to 802.11g devices? Thanks.

    Networking Channel ATE30 pointsBadges:
  • How do I retrieve the most recent date from an access database

    I am building a report in Access 2003 and am trying to pull data based on the most recent service call for a customer. There is typically several service call dates for each customer, but the only record I am concerned with is the most recent date.

    TheMooseRI15 pointsBadges:
  • How to show list view in Microsoft Access report

    i sample out some of the data from database. i shows my sampling in a listview in visual basic 6.0. now i want to show the sample to microsoft access. how's the coding?

    Yeohcc10 pointsBadges:
  • how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.

    how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL

    It doubts85 pointsBadges:
  • Join clause vs. nonequi join

    pls help, can using clause is simmilar to non equi join,if yes how is it

    Muktioracle50 pointsBadges:
  • DB2: Optimizer not using any indexes

    I have DB2 version 8.2 installed in AIX one thing I am seeing is strange that optimizer not using any indexes. In any simple join index are not being used. Is there any parameter which needs to be set up?

    AS400 - Ask the Expert485 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:
  • Nonequi join and self join as inner join

    pls Help, can we call non-equi join and self join as inner join ,if yes pls give some resion

    Muktioracle50 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 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