• Do I need SQL?

    DO I need it? I am just a home user anf oerform simole tasks, but have 8 examples of SQL programs in my program list. I have win 7 64 bit O/S

    0 pointsBadges:
  • IN and Exists in SQL?

    What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

    Prcvjr220 pointsBadges:
  • Deleting unmatched records from a file in iseries SQL

    I'm trying to delete unmatched records from file A based on file B. The files are matched by ListNo. Code: DELETE FROM DVMURRAY/INSRP100                                   WHERE SHListNo = ALL                                     ...

    PSMurray530 pointsBadges:
  • Using SQL to insert records into a table

    I have a table with a period in the table name, i.e. AB.CDE that I need to insert some records into. When I query the table (Select * from "AB.CDE") it works fine. When I try to insert records (insert into "AB.CDE"), however, I get a file not found message. Does anybody know why this is happening?

    GaryF60 pointsBadges:
  • ORA-1555 insert table with 3 billions rows in Oracle with SQL

    I have a big table with 3 billions rows and would like to rebuild in a less period of time as possible. I ran 3 plsql scrits , each plsql script is doing a full table scan to get 3 diferente range of data and insert in a new table , the commit in the cursor is for each 200.000 rows ( forall ) ,...

    Mrosa0015 pointsBadges:
  • Can I direct query the Oracle database with SQL Plus?

    I am about to start work on a SAP system which has an underlying Oracle(version 10) database. I would like to know if it straightforward to query the Oracle database directly iusing SQL*Plus for example ?

    Mikecold10 pointsBadges:
  • How to update data for one column in MS SQL?

    Hi, I have a table column named "Question" that stores the question without space.For example "Who are you" is stored as "whoareyou".Now I have modified the code to store the data with spaces in Question column.Problem is newly added data will be stored with space,but I want to change the already...

    Santhoshnk735 pointsBadges:
  • How to write text into textfile using SQL 2000

    can I use exec sp_OAMethod 'c:osqloutput.txt', 'WriteLine', Null, 'hello' to write something on file using sql2000

    Pkaur65 pointsBadges:
  • Error Message ORA-00903 in SQL table

    Here is my query:   select guestid, guestfname, guestlname from guest where tourid = 6; It says tourid is an invalid identifier. TourID is a defined attribute in a table called Tour. I'd be grateful for any help.

    Kmuller5 pointsBadges:
  • How to add an article in transactional replication in sql server 2005?

    How to add an article in transactional replication in sql server 2005? and what are the prerequisites for trnsactional replication?

    Suneelsqldba5 pointsBadges:
  • SQL SERVER SAN Setup

    I do not know much about SAN's, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a local drive on the server?

    Rick Martinez585 pointsBadges:
  • Embedded SQL number of days between dates

    C/EXEC SQL                                C+ INSERT INTO SERIOVR60                  C+ SELECT HTSERN, HTPART, HTQTY, HTSTKL,  C+ HTSTS,  HTADAT,                        C+ substr(HTPART, 1, 11) AS HTMODEL,      C+ HTADAT -...

    NickHutcheson11,380 pointsBadges:
  • SQL Agent in SQL environment?

    what is SQL Agent in SQL Environment?

    Prcvjr220 pointsBadges:
  • oracle internet directory application developer’s guide — dbms_ldap_utl sample code doesn’t work

    Hi, all I'm trying to set up Oracle Internet Directory Rel 9. I'm trying to use APIs provided in Application Developer's Guide. I started by copying and trying to run the examples given in the guide. My procedure connects to LDAP, authenticates me, but won't create a user. (Actually, it passes the...

    Paulina0 pointsBadges:
  • Importing a “flat” field into a Lookup Table format in SQL database

        * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...).     * I have created a table...

    Roguetexan5 pointsBadges:
  • Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?

    What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

    NewnanIT1,110 pointsBadges:
  • Cannot forward events from SQL Server 2005

    I'm trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server.  What must I do to see other servers in the Event Forwarding Server drop-down box?

    Bmajor5 pointsBadges:
  • SQL performance vs. Internal pgogram database access

    Is SQL access to a database faster than using the file internally within a program? Assuming that the following: The program was coded to use the keyed index. The SQL statement is coded to use the index that exists on the logical in the most efficient manor.

    Crookedpinkies0 pointsBadges:
  • SQL SERVER 2005 Database Options

    We have a database in production that is 500GB, what are the pros and cons for setting the "Page Verify" option to "NONE" on the database for best performance? How will "TORN_PAGE_DETECTION" and "CHECKSUM" affect performance?

    Rick Martinez585 pointsBadges:
  • SQL Server 2005 Memory

    I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro's that sql server can only use 4GB of RAM is that true?

    Rick Martinez585 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