• SQL COMMAND to see table relation

    Which command I can use to get the relation between all tables in a system application?

    Arielmx5 pointsBadges:
  • Is it possible to find out the name of an excel worksheet

    I need to import details from Excel but the worksheet names are not always what is expected. Is there a way to determine the worksheet name using sql? Query used to import where sheet name = data SELECT * INTO tmp_test2 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel...

    Smf170 pointsBadges:
  • SQL Query for time data only

    I need to query a large remote weather database for events reported within time frames without regard for the day. For instance, I need all data that was reported for the fifteen minute window closest to noon each day for the last twelve years. I don't care about specific dates, just the daily time...

    C Pete15 pointsBadges:
  • Looking for a stored procedure to monitor size of Transaction Log file

    Is there any way I can create a stored procedure which will check for the Transaction Log file size - where we have a specified limit to grow - and if the Log file reached 80 percent of total size, email alerts can be sent to DBAs?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Count several columns Group by accounts Greater than value Beginner

    I need to be able to count how many values are greater than 1 for each StuNum. I have only been able to count how many values are greater than 1 for each StuNum for d1 or for d2 or for d3, but not for d1, d2 and d3. How can I have it count multiple columns. Table StuNum – SchNum – Tchnum – d1...

    Ben Pinto5 pointsBadges:
  • in what direction should i work

    i did degree in electronics and communication after that i did job in sofware company for 8 months as assistant system engineer with cobol, sql technology. i have basic knowledge of c, cobol, sql and html. what kind of job should i search, i need one more suggestion that in which field i should go...

    Canny5 pointsBadges:
  • Alternatives to ODBC

    Our db group wants to remove ODBC access. My application relies on ODBC to get data. What are the alternatives?

    Chany25 pointsBadges:
  • rpg sql concat

    Our database was designed with separate fields for cc, yy, mm and dd. I'd like to know if and how these fields can be combined into one field then order by on that field. Is this possible? I would need to know the syntax also. If this is not possible, then is there a another way to order by...

    mcg15 pointsBadges:
  • Truncate or not Truncate SQL

    What are the pros/cons of truncate a table export/import to just drop table?

    Jay Dog5 pointsBadges:
  • What more do I need to do to get instant client working with IIS?

    I have installed instant client on my XP computer and am able to connect to a remote Oracle 10g server with SQL plus using this string: sqlplus myid/mypassword@//server:port/svc I have also been able to make a DSN file that connects, and have been able to connect with Visual Basic. I HAVE NOT been...

    OracleATE190 pointsBadges:
  • MySql Query

    Hi Gurus i have a problem in MYSql Query Browwser there is a table "jiuser" in "jasperserver" database. this table has a column "username". there is another table " jiresourcefolder" in the "jasperserver" database. this table has a column "uri". now i wana find out which user can access which uri....

    Abhi Here20 pointsBadges:
  • Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    Are there any issues with setting up SQL Server 2005 log shipping with TDP & TSM?

    SQL Server Ask the Experts2,585 pointsBadges:
  • DATETIME calculation

    Hi there, this is probably very simple but i just can't get it working. I want to subtract one month from a variable month. So if the datetime variable is equal to 10 Feb 2008 the result should be 10 Jan 2008. Please help. Thanks

    Barend IT15 pointsBadges:
  • list sales by year

    You are to generate a set of sales reports using the tables above. 1) Build a rpeort of sales by year (you can use order total colum) 2) Expand this to include the employee name of the sales rep so now you will show sales by rep by year 3) Also get the sale reps job descriptio and see what type of...

    Kkd7775 pointsBadges:
  • Converting from 2000 to 2005

    I was given an existing application/database with stored procedures to work on. The existing database is in 2000 however the manager would like it converted to 2005 (she thought it already was a 2005 database). My system is only configured for 2005 so my analysis tools are not working on the...

    GUI Girl5 pointsBadges:
  • Duplicate Spatial Data

    I"m looking for some help on how to find duplicate geometry for area, line and point features that are stored in an spatial SDO database. Any help would be greately appreciated. Regards, Sam

    SamAvella30 pointsBadges:
  • SAP HR

    Hi, what are the tables in SAP HR to select the name and salery with sql on oracle

    Wolloc5 pointsBadges:
  • Stored Procedure Problem

    Hi Greg, I am using SQL queries as in-script and now decided to use them as stored procedure. I am facing some problem while converting them into stored procedures. It’s a book search functionality based on book name and author name. My Old SQL query, which I was using with asp. SQL = “Select *...

    Anilak singh5 pointsBadges:
  • HOw to Find Duplicate Geometry in Oracle Spatial

    If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if she\he can share this with me. A million thanks in advance... Regards, Sam

    SamAvella30 pointsBadges:
  • SQL multiple files

    On our iSeries I need to find out if fld01 or fld02 or fld03 in file "C" contains a value that is obtained from file "B" using a value from file "A". How would I do this using SQL?

    Floyd02320 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