• How to create a SQL database

    I want to create a SQL database. What are the software requirements and where do I get the software?

    DouglasMonaco45 pointsBadges:
  • Indexes: I need a simplified explanation on indexing using composite search keys

    Please, I need a simplified explanation on indexing using composite search keys in SQL.

    Cliffokwy5 pointsBadges:
  • Subfile sort

    I have a subfile program for updating, creating, and displaying item information the user can select from to create, view or update detail. The subfile shows item number, description, etc from my main file (i'll call itemnum1)and a vendor item number from an auxiliary file (itemnum2). My question...

    filuphaze475 pointsBadges:
  • I/O error 23(Data error (cyclic redundancy check)

    I have encountered the below error message when I try to do SQL query. Server: Msg 823, Level 24, State 2, Line 1 I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x000001ac1c4000 in file 'C:\sql\PDB_Data.mdf'. Did a DBCC CHECKDB (PDB) WITH NO_INFOMSGS,...

    ronanggl5 pointsBadges:
  • Convert Filemarker database to SQL database

    I'm trying to convert filemaker15 database to SQL database using file maker migrator but it takes a lot of time and nothing happened?

    Reyan15 pointsBadges:
  • Keyboard shortcut for switching panes in SQL Developer

    I use SQL Developer all of the time at my job. It's one of my favorite programs since I can divide my screen multiple times (For example, I can edit a SQL file and view at file at the same time). Here's my question: Is there some keyboard shortcut that I can use to switch between the different...

    ITKE1,042,485 pointsBadges:
  • Create a table in SQL

    How can I create a table in SQL?

    rachaputi5 pointsBadges:
  • Encountered error when running the procedure in SQL

    Hello Experts, I got Error (5,3): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: **statement** CREATE OR REPLACE PROCEDURE spGetCustomer IS BEGIN SELECT CUSTOMERID, CUSTOMERNAME FROM CUSTOMER_T END; What seems to be wrong?

    lopezr5 pointsBadges:
  • SQL: Remove specific records from one table based on records present in another table.

    Suppose we have two tables T1 and T2 as described below: T1:- Col 1 Col2 Valid 1 a 120 2 b 232 1 b 435 3 a 123 2 c 532 T2:- Col 1 Col2 Invalid 1 a 1133 2 b 2321 2 a 4234 Now what can be the simplest query to remove all the records from T1 which are also present in T2 having the same values of both...

    raghvendra25125 pointsBadges:
  • SQL amend data field to add network path

    I'm looking to amend an SQL data field. The database is dbo.CaseInfo the field is FilePath. Currently the data field says 201706\18041_06292017_145141_01.asf. I need to add the new network path to have it look like this. Z:\201706\18041_06292017_145141_01.asf There are over 20,000 entries and I'm...

    lostbug55 pointsBadges:
  • Oracle SQL in TOAD

    Run a query that returns the number of trouble tickets in the VTM024… table, but only the ones created in the year 2015. Note: when setting the where criteria, use a function to extract the Year portion from the timestamp field. Using the Year function in the first answer, write SQL that shows...

    faizanahmad2330 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER220 pointsBadges:
  • Is RPG quicker than SQL to update ALL records

    We update a few fields in every record on a file with over 13 million records. Masking a copy of production data on a performance test environment. It is run on a two processor 595 box under OS7.1. The job runs for about 36 hours. If I wrote an RPG program, I would open the file non-keyed to...

    ShadowProgrammer15 pointsBadges:
  • Send email through procedure in PL/SQL

    Dear Team, I want to make a procedure through which I can send email to my team mail id. Actually there are number of procedures running daily in our system. So I want to send the status of each procedure means if procedure is getting success,failed or running. If the procedure is in running state...

    Biswa9215 pointsBadges:
  • SQL Join keeps failing

    Hello everyone, This question comes from one of our power users: ToddN2000. I'm trying to join 2 tables and it keeps failing. I did not create the tables and I cannot change them. One has the order defined as NUMERIC(8) the other has the order defined VARCHAR(15). I have tried using CAST, CONVERT,...

    Michael Tidmarsh58,150 pointsBadges:
  • sap training

    where is a good place to start to take sap training?

    Tsscare5 pointsBadges:
  • DB2i SQL select max(field) not using keyed access path

    I have a file that contains a timestamp field. This field is also the key field for the file. I am running a select statement in a UDF for the max value of that field, but according to the Query Access Plan: arrival sequence access was used for the file because the left-most key of the access path...

    BigKat9,000 pointsBadges:
  • How to recover deleted tables from SQL Server

    I have created tables in sql server 2005 but some how all the tables get deleted so can anyone tell me a way by which i can recover my deleted tables.

    Christinamarley5 pointsBadges:
  • SQL: Using Instead Of Update to allow updates by certain users

    I want to use an Instead Of Update to limit updates by Admins only. I have the code for the case when it is not an Admin doing the update but if the user is an Admin do I have to manually code the update for the table for every field from the inserted table?

    kul2bme5 pointsBadges:
  • Visual FoxPro Remote view

    Currently I'm doing SQL migration through remote view to my new product. In this, how to handle the following case. Single application will be access by each user and SQL DB in common server. Remote view [dbc] also common to all users. When one user add one record to a master table, how the changes...

    actramesh0015 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.

Thanks! We'll email you when relevant content is added and updated.

Following