I’ve been given an Oracle DB that has some triggers and “LOAD DATA” jobs. Is there a tool/utility to convert the triggers/loads from PL/SQL into T-SQL?
Answer Question | June 23, 2011 9:20 PM
Database conversion, Oracle import/export, Oracle triggers, PL/SQL, SQL, T-SQL
For All IT I have Data string “123″. How to create procedure (MySQL) for string “123″ to Be : 1. 123 2. 132 3. 231 4. 213 5. 312 6. 321 Point 1-6 is array. Please Help Me an Thanks Thanksss
Answer Question | April 10, 2009 6:27 PM
MySQL, MySQL Stored Procedures
Hi, I’m going to try to implement a barcode system to keep track of inventory. I was wondering if anyone can suggest the best handheld scanner to get that will let us scan several barcodes and then dump the scans into a text file? Or if anyone know of another better way to accomblish this. [...]
Answer Question | April 1, 2009 6:26 PM
Barcode, Barcode Readers, Barcode scanners, Microsoft Access, VBA, Windows XP, Windows XP Professional
I want to have a field where the date the form was printed out populte that box in Access 2007. How do I set this up?
Answer Question | April 1, 2009 2:19 PM
Access 2007, Access Custom Fields, Microsoft Access
i want to learn the oracle9i for get the job of DBA .for that what website i have to go?
Answer Question | March 30, 2009 1:22 PM
DBA, DBA training, IT careers, Oracle 9i
I have an excel file that contains an image in the first col. When I save it to an csv format, the excel program creates two images ( 1 small, 1 large) for each line in the excel file. How do I load both the file data and the large image into my mysql database?
Answer Question | December 19, 2011 11:57 AM
Database programming, Microsoft Excel, MySQL
Data from the form not able to add into the database although using Internet sample source code.
Answer Question | March 30, 2009 8:08 AM
Active Server Pages, ASP, Database connectivity, Database programming, Microsoft Access, Web development
I would like to know if it is worth the money for IT training. I met with someone from a company called New Horizons. Their network admin program includes the books, practice labs/exams, job placement assistance, and mentored learning to obtain 4 certs which are A+, Network+, MCP, MCSA. The cost of this program is [...]
Answer Question | February 14, 2011 7:34 AM
A+, Certifications, IT careers, IT education, IT training and certifications, MCP, MCSA, Microsoft certifications, Network+, Networking certifications
oracle to ms access
Answer Question | March 31, 2009 9:32 AM
Database migration, Microsoft Access, Microsoft Access import/export, Oracle import/export, Oracle migration
Is the CCENT the Cisco equivalent to the Comptia Network+ ? I want to learn basic networking fundamentals before I take on the CCNA.
Answer Question | September 16, 2011 11:09 PM
CCENT, CCNA, Certifications, Cisco certifications, Cisco Certified Entry Networking Technician, Cisco Certified Network Associate, CompTIA Network+, IT careers, Network+, Networking careers and salaries, Networking certifications
how to connect oracle9i to vb6 by odbc? plese provide me code also?
Answer Question | April 1, 2009 12:45 PM
ODBC, Open Database Connectivity, Oracle 9i, Oracle connectivity, VB 6, Visual Basic 6
Where can I get instructions on using Microsoft Access to create reports from Macola?
Answer Question | March 27, 2009 6:29 PM
Access reports, Macola, Microsoft Access, SQL Server
I developed and tested a VB6 program that runs CR Viewer accessing with RDC Crystal Reports 11 reports from a folder on a remote server and uses data and queries from SQL2000 on the same server. All operating systems use MS XP. My problem is that the program works on my desktop and a few [...]
Answer Question | March 27, 2009 11:40 AM
CRViewer, Crystal Reports 11, Crystal Reports XI, Database connectivity, SQL, SQL Server 2000, SQL Server connectivity, VB 6, Visual Basic, Visual Basic 6
Hi everyone, I would like to know how to in a step by step process export date from AS/400 iseries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report [...]
Answer Question | March 27, 2009 2:02 PM
AS/400, Exporting AS/400 to Excel, iSeries Access, Microsoft Excel, ODBC
I have set up a SQL link server between an SQLserver 2005 on a W2003 R2 and a SYBASE 184.108.40.206 server on a IBM AIX H70 system. I use the Sybase ODBC driver 04.20.00.67 The problem is than most of the times (there is no pattern ) when I select rows from a Sybase table [...]
Answer Question | March 30, 2009 9:27 AM
Database connectivity, IBM AIX, Linked Server, ODBC, SQL Server 2005, SQL Server connectivity, Sybase 220.127.116.11, Sybase connectivity
Hi, I am really confused about way to follow to become a Security Auditor… and the opportunities it has in future.. esp. in India ?? Currently I am working as a Security Consultant but dealing only with Security Related products including Firewalls, NMS, IPS etc and not Standards like BS7799, ISO27001, CoBit etc.. Being in [...]
Answer Question | February 29, 2012 8:22 AM
CCIE, Certified Information Systems Auditor, CISA, Cisco Certified Internetwork Expert, Information Security Management System, ISMS, IT careers, Security auditing, Security Auditor, Security audits, Security careers
i have an table in sql-server 2005, in which my one field is storing csv values. suppose i have two tables; one is roles and another is users; and multiple role can be assign to one user. so that i have make a fields i.e roles in user table which is keeping the values in [...]
Answer Question | March 26, 2009 7:18 AM
CSV, CSV file format, CSV format, SQL Server 2005
When I perform a Paste Append into the table, the field I need that is a hyperlink is being truncated, thus link fails. How can I get the link to pates exactly as is from Excel?
Answer Question | March 30, 2009 10:51 PM
Hyperlinks, Microsoft Access, Microsoft Access tables, Microsoft Excel
I am developing an on-line screen program, where the user can select a view of the data from a list of “views”. This is my first crack at embedded SQL, Basically i issue the Prepare, declar the c1 scroll cursor, and then open c1, and then do the fetch. At this point I am loading [...]
Answer Question | March 26, 2009 5:17 PM
Embedded SQL, RPGILE, SQL
I have a series of MYSQl Tables that I want to inspect via a web page, generating the logic to simply display the data is straightforward, however, it’s tedious to create each page then write the logic to make the data editable. Since it’s largely repetition it should be fairly easy for someone to have [...]
Answer Question | March 27, 2009 3:04 PM
ASPX, MySQL, VB.NET, Visual Studio