19 Resources for

sql statement

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

phpMyAdmin (zip): phpMyAdmin is a tool developed in PHP and is intended for handling the administration of MySQL over the Web. Currently phpMyAdmin can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields. Version 2.11.4 RC1 includes unspecified updates.; Tags: SQL Statement, phpMyAdmin Devel Team, Databases, Scripting Languages, Workforce Management, Open Source, Enterprise Software, Software, Data Management, Software/Web Development, Web Development, Human Resources; Software downloads 2008-01-10
How do I... Add items to an Access combo box on the fly?: List controls in Microsoft Access, such as the combo box and list box, offer choices to the user. From their point of view, they don't have to enter anything -- they simply select an item. From the application developer's perspective, the database is protected from typos and other erroneous data....; Tags: Box, Response, Solution, Microsoft Access, Item, Control, Property, Truth, Difference, List, Form, Table, NewData, acDataErrContinue, Limit, Yes, Iron, SQL Statement, Gold, Databases, Microsoft Office, Programming Languages, Enterprise Software, Software, Data Management, Office Suites, Software Development, Software/Web Development, Susan Harkins; Blog posts 2008-02-07
Database Fishing Tool (exe): Database Fishing Tool DaFT is a front-end to any database that can be connected to with an ODBC driver. DaFT allows you to browse the database objects, view data in tables and views, and create and execute SQL statements, also as a script, including variable scanning. DaFT contains a database...; Tags: SQL Statement, SQL, Tool, ODBC Driver, ITFT, File Format, Databases, Storage, Programming Languages, Enterprise Software, Software, Data Management, Hardware, Software Development, Software/Web Development; Software downloads 2005-07-28
How do I... Populate an Access list control with the results of a dynamic search?: This information is also available as a download that includes a sample Access database demonstrating the solution we'll build here.Most applications have at least one search task. For instance, you might populate a form with product data by choosing the product's name from a combo box. That solution is simple...; Tags: Office and Productivity, How do I; Blog posts 2007-07-30
How to write a SQL statement in VB6: I am trying to create a report in VB6 where the the user picks 2 different dates and the results are then sent to a datareport to be printed. My problem is I do not know how to incorporate my user defined dates into the SQL Statement. Nor do I...; Tags: Programming languages, Terris2000@..., SQL, SQL Statement, Microsoft Visual Basic 6.0; Discussion threads 2007-07-21

SQL Statement: I know that something is wrong with my Where clause. Will someone show me. I have tried all I know.‘To fill the Grid with data that matches the Value in cboPayCombo Dim strSuit As StringstrSuit = cboPayCombo.TextstrQuery = "SELECT tblInfo.fldSuit, tblInfo.fldRCR, tblPayments.fldPDate, tblPayments.fldPaid, tblPayments.fldBalance, tblPayments.fldCashier, tblPayments.fldRecNum, tblPayments.fldVchNum,...; Tags: belcredit@..., SQL Statement, SQL; Discussion threads 2007-06-25
Gather query tuning data via Oracle's dynamic performance views: The dynamic performance views supplied with the Oracle database include several that make the process of gathering tuning information easier. This tip describes four of them: V$SQL, V$SQLAREA, V$SQLTEXT, and a new one, V$SQLSTATS. For several releases now, DBAs and developers have had access to three dynamic performance...; Tags: Oracle Corp., SQL, V$SQLAREA, V$SQLTEXT, V$SQL, Databases, Bob Watkins, Programming languages, SQL Statement, performance, Oracle Tips Newsletter, View, Performance View, COMMAND_TYPE Column, Performance Management, Human Resources, Workforce Management, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2007-03-06
Parsing query from VB Application to Data Report: Hii,I want to send the sql statement from vb application to the datareport, and wants to call the data report. Please help me out with example code to change the sql statement already made with the data report through VB application.Thanks and Regards.; Tags: Programming languages, Microsoft development tools, anwer0008@..., data report, sql statement, VB Application, Microsoft Visual Basic; Discussion threads 2007-05-19
Lock it down: Use the revised OWASP Top Ten to secure your Web applications -- Part 3: This article is also available as a TechRepublic download.Inthis installment of my series on the revised OWASP Top Ten List of Web applicationvulnerabilities, I take a look at number two on the list--injection flaws. We'llbriefly explore injection flaws in general, and then dig into more detail onSQL injection vulnerabilities. Susceptibility...; Tags: Programming languages, Databases, SECURITY, Tom Olzak, Web application, SQL, SQL injection, SQL Statement, database; Technical articles 2007-03-23
Format EXPLAIN PLAN results easily with Oracle's DBMS_XPLAN: When you need to troubleshoot inefficient SQL, one of the most important diagnostics tools at your disposal is the output of the EXPLAIN PLAN command. Find out how Oracle's DBMS_XPLAN functions can help you tune your SQL statements. One of the most important diagnostic tools in troubleshooting inefficient...; Tags: Oracle Corp., SQL, DBMS_XPLAN.DISPLAY, Databases, Bob Watkins, Programming languages, execution plan, Explain Plan, SQL Statement, PLAN_TABLE, DBMS_XPLAN, Oracle Tips Newsletter, Listing B, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2006-05-16
How do I... Transfer and store data from an XML document in a relational database?: This article is also available as a TechRepublic download, which includes the code listings in a more manageable text format.BetweenAJAX, Web services and just plain XML there is a plethora of information going to and fro.Yes, XML really makes it easy to move data from here to there and from...; Tags: Â Â Â Â, Â Â Â Â Â Â Â, database, Edmond Woychowsky, RDBMS, Software engineering/development, SQL, SQL Statement, XML, XML document, XSL; Technical articles 2006-11-17
SQL statement: I am creating a where statement showing not like fields. But I want to show all in the range. ie. combo = fc item = fc, reNot like statement will show item re, but I want to view the fc alsoPoint value changed by...; Tags: SQL Statement, Components, cjconnell@..., programming, Component, EDP, Qty, combo cost, subgroup, Component Component Ext Comp Component EDP, SQL; Q&A 2006-08-11
Using ODBC within a .NET application: Tony Patton explains how you can set up and work with Open DataBase Connectivity ODBC technology in your .NET applications. He also highlights the ODBC .NET Data Provider, which provides ODBC access within .NET applications through the Microsoft.Data.Odbc namespace. One of the .NET Framework features often highlighted is...; Tags: Tony Patton, .NET Newsletter, TechRepublic Inc., Application, ODBC, Microsoft .NET, Driver, Connection, .NET Data Provider, Driver Manager, SQL Statement, ToString, Databases, Enterprise Software, Software, Data Management; Technical articles 2005-07-20
Use SQL to quickly summarize Access data by group: OverkillWhy is it that people have such a misconception about the superiority of using SQL? A query like this can be built much quicker and easier by using the query design view. There is absolutely no reason to manually type a query in SQL mode at least 99%...; Tags: SQL, access, query design, scott44, hardware, Microsoft Access; Discussion threads 2006-02-08
Recover from import errors in Oracle: When an import runs, it creates tables and loads data before loading other schema objects such as views, synonyms, and sequences. If the import fails after table creation and loading, check out a technique that you can use to continue manually using SQL*Plus. TechRepublic's Oracle newsletter covers automating Oracle...; Tags: Oracle Corp., SQL, Databases, Scott Stephens, Programming languages, SQL Statement, database, Oracle Tips Newsletter, TechRepublic Inc., Oracle9, Listing C, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Technical articles 2005-04-26
Oracle PL/SQL: When i use the Oracle built-in function GET_APPLICATION_PROPERTY within the sub-query of an sql statement i get an error which states "You may not use GET_APPLICATION_PROPERTY function in SQL"...what can be the workaround for this problem?Sounds like you're using forms. Since you did not post the sql statement, I...; Tags: Programming languages, SQL; Q&A 2005-07-17
Microsoft JDBC Type - 4 drivers: We are converting our legacy application to run on Java. We use ODBC drivers shipped with SQL Server 2000 to connect to the database. On the java side we began to use JDBC type 4 drivers. WE noticed that the sql statements being sent over to the database via jdbc...; Tags: database, JDBC, Microsoft Corp., ORASU, software, SQL; Discussion threads 2004-12-14
Tech Tip: Locate the last edit in Word/Add Excel graphics to chart data/Create an Access SQL statement: Quickly return to the location of the lastedit When you need to review the last edit made to avery large document, you don't need to scroll and read through theentire document to find it. Word automatically remembers the lastthree locations where you've entered or modified text....; Tags: graphics, Microsoft Access, Record Source, Record Source property, SQL, SQL Statement; Technical articles 2004-08-02
Boost Oracle performance with intelligent optimizer limits: The most important component of Oracle SQL execution time is the time spent preparing a new SQL statement for execution. But by understanding the internal mechanisms of the generation of the execution plan, you can control the amount of time Oracle spends evaluating table join order, and boost the performance...; Tags: Programming languages, Databases, performance, optimizer_max_permutations initialization parameter, Donald Burleson, SQL, Oracle Corp., SQL Statement, execution plan, optimizer, optimizer_search_limit; Technical articles 2003-02-11

Additional Resources

General SQL Parser .NET version (zip): General SQL Parser is developed to help people who want to check syntax of SQL statements, pretty print out SQL statements, and parse SQL statements into parse tree in their program. It can also provides more detail information about a SQL statement such as statement types (Select, insert, update, delete...; Tags: Microsoft .NET, Statement, SQL, General SQL Parser, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management; Software downloads 2006-12-07

<< Previous
page 1 of 1
Next >>

Content Types

Blog posts (2 results)

Discussion threads (5 results)

Q&A (2 results)

Software downloads (2 results)

Technical articles (8 results)

Microsoft Excel Beginner: This Microsoft Excel - Beginner presentation is a preformatted solution for training staff to understand the basics of Microsoft Excel. The accompanyi ...; Buy Now

TechRepublic's IT Hardware and Software Purchasing Policy: Your IT Budget is tight. You want to get the most bang for your IT buck. That's where the IT Hardware and Software Purchasing Policy can help. This p ...; Buy Now