• VFP9 DBF to Ms SQL

    is there tools available for converting VFP9 DBF to Ms SQL? or what is the best approach? thanks.

    B385 pointsBadges:
  • SQL Macro

    I need a SQL macro to populate a form? Please help. wkharrell@gmail.com

    SAS70ExPERT125 pointsBadges:
  • sql server 2000

    i am learnin sql server 2000 by ownself tell me the wright way how i can learn after this i shall go for oracle

    Agnihotri0 pointsBadges:
  • Oracle 10g Standby Database not opening readonly

    Hiii, I have created Oracle 10g Primary database where control file locations are as follows: *control_files='P:\oracle\product\10.1.0\oradata\tceng\control01.ctl','C:\oradata\tceng\control02.ct l','E:\oradata\tceng\control03.ctl' Then I have created standby database in standby server where the...

    Ora dba20 pointsBadges:
  • Execution time is varying with query analyzer and visual studio 2005

    when a stored procedure is executed in query analyzer its working fine and getting the result quickly.but when same procedure is executed through visual studio timeout expired error is generated.can any one olve this issue

    Abcp5 pointsBadges:
  • replace field with count variable in foxpro

    Hello, in Foxpro 6, I need to replace a field with the count from a memory variable when an invoice # is the same. The database lists the detailed line items of the invoice and the invoice # next to them. So, if invoice 56 had two items, I would need 1 in the count column for item 1 and a 2 in the...

    Prep895 pointsBadges:
  • Return zero when there’s no data

    I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row returned,...

    DanM5 pointsBadges:
  • Random number generation

    Hi, I have a 6 digit number. I need to make this as a 10 characters with those 6 digits within it. For eg, if my input number is 123456, the result should be a4y2d365p1. some combination of characters with the original 6 digit numbers. Please do let me know if this could be done by any ways..

    Coolgirl045 pointsBadges:
  • Using xp_cmdshell

    Hi, I am using xp_cmdshell in one of my stored procedures(database SQL server) to delete older files from a folder in another server. That server is mapped as a network drive on the sql server computer. But when I used this drive inside xp_cmdshell command and do a dir , the output I get is 'Access...

    Gullu15 pointsBadges:
  • Select last 3 transactions

    Hello Can someone help me to put together an SQL statement to select the last 3 transactions from a transaction file. In TransactSQL I would do something like this: select top 3 CustID, TransDate, Amount from Trans where CustID= '12345' order by TransDate desc. I believe there must be a more...

    SuhelAC0 pointsBadges:
  • SQL and Moss 2007 from Jameel Ur Rahman (Abbottabad)

    hi, I recently done Moss 2007 certification . an di want to know the relation of SQL and Moss 2007 , and also let me know for Moss 2007 implemention how i prepaer my self regarding SQL because SQ L new for me any book or white paper that help me and also SQL 2005 Administration thanks jameel

    Jameelrk5 pointsBadges:
  • How to install a passive node on an active/active SQL Server cluster

    We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. Because...

    SQL Server Ask the Experts2,585 pointsBadges:
  • “GET DIAGNOSTICS” SQL Procedure

    I am currently writing an SQLCBLLE Program on a V5R2 box. I would like to use the SQL Procedure "GET DIAGNOSTICS", however each time I enter it into my code the both SEU and the compiler complain about it. I receive the message GET was not expected. I know the procedure was supported in V5R2 but...

    FCARPENTER200 pointsBadges:
  • Combined Address

    I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...

    Thuzinec10 pointsBadges:
  • Moving a SQL database from one host to another

    I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...

    Kwoodall10 pointsBadges:
  • Linux vs Microsoft

    what is the Linux equivalent for SQL Server? Also, what is the difference between the two?

    Jaco65 pointsBadges:
  • Embedded SQL in a Cobol program using a sub-select in the select clause

    The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = 'Y' SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE...

    Warpmail5 pointsBadges:
  • SQL linking to database in XP

    First of all, I tried to create an ODBC connection to a local SQL database. It successfully created but it does not show up. I know it is there because I can link to it via Access or if I try to create the same one again, it tells me it is already there and if I want to overwrite it. In trying to...

    Bigblew15 pointsBadges:
  • What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?

    What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?

    SQL Server Ask the Experts2,585 pointsBadges:
  • oracle multi-field row query with more than one row

    I have a table that specifies the year, and a quantity for each month, in the same row. I need to get a 12 month rolling average, which involves particular fields from one row, and addition fields from another, based on the sysdate. There are several tables that need to be joined to ensure I have...

    Seashellm150 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