On The Insider: Heidi Klum's Legs Worth $2M
1 Resources for

sql statements

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Access query
I currently have a linked DBF extract from my Primary system that includes 2 fields; one with the date, and another with the time. I need to be able to capture data for a 24 hour period of time beginning at 3:00am in the morning and ending at 2:59:59 in...
Tags: access, Access Query, database, dateTime, FHP, microsoft, Microsoft Access, queries, software, sql statements
Discussion threads 2006-01-17

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
SQL Tools Make Fast Work
The purpose of any interactive SQL tool is to let the user enter SQL statements and get results back. The term SQL statements includes PL/SQL blocks and now, in Oracle Database 10g Release 2, XML queries. SQL*Plus has long been the tool of choice for executing ad hoc SQL statements,...
Tags: Oracle Corp., SQL, Tool, SQL*Plus, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
White papers 2006-01-01
Better Workload, Better Testing
One of the most important processes for testing the impact of system changes - both hardware and software - on a database is setting up a test environment that faithfully represents the database's actual workload. Although it's possible to write SQL statements that reflect business functionality, it's a task that...
Tags: Statement, SQL, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware
White papers 2008-01-01
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
Finding and Fixing Bad SQL in Microsoft SQL Server 2000
This paper will teach you the basic techniques used to find and fix poorly performing SQL statements (usually SELECT statements, but also INSERT, UPDATE and DELETE statements) on Microsoft's SQL Server 2000 relational database management system. The paper will teach you the techniques available using Microsoft's native tools, such as...
Tags: Technique, Microsoft SQL Server, Microsoft SQL Server 2000, SQL, Microsoft Corp., Quest Software Inc., Productivity, Databases, Performance Management, Programming Languages, Enterprise Software, Software, Data Management, Human Resources, Workforce Management, Software Development, Software/Web Development
White papers 2005-04-01
Advanced SQL To HTML Table Converter (msi)
Advanced SQL To HTML Table Converter is a relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select statements are automatically persisted as HTML and CSS tables to a directory of your choice. Version 1.2 includes...
Tags: HTML, SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2007-12-20
Tuning SQL Statements on Microsoft SQL Server 2000
This paper covers the basic techniques used to tune SELECT statements on Microsoft's SQL Server 2000 relational database management system. The paper discusses the techniques available using Microsoft's graphical user interfaces provided in Microsoft SQL Enterprise Manager or Microsoft SQL Query Analyzer, as well as provides a brief overview of...
Tags: Microsoft SQL Server, Microsoft SQL Server 2000, SQL, Microsoft Corp., Quest Software Inc., Productivity, Databases, Enterprise Software, Software, Data Management
White papers 2005-06-01
Advanced SQL To XML Query (msi)
Advanced SQL To XML Query is a relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server databases. Resultsets returned by select statements are automatically converted to XML files and persisted to a directory of your choice. XML files generated by Advanced SQL...
Tags: SQL, XML Query, XML, Programming Languages, Databases, Software/Web Development, Web Development, Software Development, Enterprise Software, Software, Data Management
Software downloads 2007-12-20
Linqer (zip)
Linqer is a SQL to LINQ converter tool. It will help you to learn LINQ and convert your existing SQL statements. Not every SQL statement can be converted to LINQ, but Linqer covers many different types of SQL expressions. Current Linqer version supports C# language only not Visual Basic yet....
Tags: SQL, LINQ, Linqer, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2008-06-22
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
CSV2SQL (exe)
It converts CSV files to SQL insert statements. Convert your CSV files into SQL statements which are ready to be read straight into your database. It works with any database server you would like to use.
Tags: SQL, CSV File, Databases, Programming Languages, Enterprise Software, Software, Data Management, Software Development, Software/Web Development
Software downloads 2005-10-05
IBM DB2 SQL Performance Analyzer for z/OS, Version 3.1
Accessing IBM DB2 with Structured Query Language SQL requires time and resources. Fortunately, a forecasting tool is available to help improve query performance: IBM DB2 SQL Performance Analyzer (DB2 SQL PA) for z/OS. This tool takes SQL statements from any input source and provides estimated query costs. It also offers...
Tags: Performance, SQL, IBM z/OS, IBM DB2, IBM Corp., Databases, Enterprise Software, Software, Data Management
White papers 2006-03-01
Info-Pack.com CSV2SQL (exe)
Info-Pack.com CSV 2 SQL is a csv file to sql insert statement converter. Use it to convert your access comma separated files into database insert statements. Simply provide an input file, some field names and an output file name. CSV 2 SQL will then create a file containing SQL insert...
Tags: SQL, Info-Pack.com CSV 2 SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2006-05-08
SQL Batch Executor (exe)
SQL Batch Executor will run SQL scripts for any database with an ODBC compliant driver. A few years ago, I created a very simple version of this application in order to do my job more effectively. Because I usually generate most of my SQL statements, I had many problems running...
Tags: ODBC, SQL, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware
Software downloads 2005-05-15
SQL generator (msi)
Easy generate SQL code from an excel document, for generating tables with data. The queries wil be stored in an .sql file wich can be used by many databases (MySQL, SQL server). Create table and the insert statements will be generated automatically.
Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2005-10-26
Advanced Database Query Automaton (msi)
Advanced Database Query Automaton is a scriptable relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select statements are automatically persisted to CSV spreadsheets. The application comes with an XML configuration file that allows users to...
Tags: SQL, Advanced Database Query Automaton, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
Software downloads 2007-12-20
DBScripter (exe)
DBScripter is an ODBC utility that creates an SQL script from any database accessible from your system. The script created can contain structure, indexes, and/or data statements to fully or partially replicate a database. The script is also fully configurable to meet all different DBMS requirements, such as special wording,...
Tags: SQL, DBScripter, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2006-07-31
SQLBlock ODBC Edition (msi)
SQLBlock is an ODBC driver with patent pending SQL injection protection feature. It works as a ordinary ODBC data source and monitor every SQL statements being executed. If the client application try to execute any un-allowed SQL statements, SQLBlock will block the execution and will send alert to administrator. SQLBlock...
Tags: ODBC, SQL, SQLBlock ODBC, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2005-12-13
Advanced SQL To RTF Table Converter (msi)
Advanced SQL To RTF Table Converter is a relational database client utility that allows execution of SQL Structured Query Language statements on Microsoft SQL Server and MySQL databases. Resultsets returned by select statements are automatically persisted as RTF tables to a directory of your choice. Advanced SQL To RTF Table...
Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Software downloads 2007-12-20
  • << Previous
  • page 1 of 1
  • Next >>


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 policy's purpose is to help properly set the boundaries for purchasing new hardware and software.
Buy Now
Best Practices for Maximizing Microsoft Access 2003
This pre-packaged presentation contains everything you need to instruct end users about how to get the most out of Microsoft Access--even if you don't ...
Buy Now

The Green Enterprise