sql syntax

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Use SQLite for a simple, lightweight database option

Learn about open source SQLite, a simple, compact database option suitable for applications that don't require large database systems. Everyone knows about open source database giants such as MySQL and PostgreSQL; these free SQL database servers are commonly used by Web applications and other programs. For some...

Tags: SQL, SQLite, Storage, Databases, Vincent Danen, Programming languages, Linux, database, SQL database, Linux Tips Newsletter, SQL Syntax, Hardware, Enterprise Software, Software, Data Management

Technical articles 2005-09-23

Additional Resources

Proc SQL - A Primer for SAS Programmers

The Structured Query Language SQL has a very different syntax and, often, a very different method of creating the desired results than the SAS Data Step and the SAS procedures. Only a very thorough manual, such as the SAS Guide to the Proc SQL Procedure, could even begin to describe...

Tags: SAS Institute, SQL, Programmer

White papers 2006-02-28

Cache Monitor (zip)

Cache Monitor is the SQL development tool designed for InterSystems database Cache. It supports developers with features, like advanced SQL Query Editor with foreign key join suggestion, Cache-SQL Syntax highlighting, SQL Code completion, SQL History buffer for executed SQL commands, SQL Code formatting, Graphical SQL execution plan. Version 0.34 is...

Tags: Monitor, SQL, Cache Monitor, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-05-11

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

Universal SQL Editor (msi)

Universal SQL Editor is a powerful, yet easy-to-use graphical tool for all database developers. It allows you to connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, and edit SQL scripts and queries with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to...

Tags: MING Software, SQL, Universal SQL Editor, Databases, Programming Languages, Storage, Enterprise Software, Software, Data Management, Software Development, Software/Web Development, Hardware

Software downloads 2007-12-28

Brand New to SQL

I am looking for the best books or resources for a beginner in SQL. Any tips?DaveAnything by...Susan Sales Harkinsor evensams publishing.they have several good books on several sql servers in the teach yourself in 24 hours / days series.Also"SQL in a Nutshell", an O'Reilly Press book is an excellent...

Tags: ddevans888@..., server, software, SQL

Discussion threads 2005-04-07

Superior SQL Builder (zip)

Visually build complete SQL scripts - other query tools only build single SQL queries. Introduce massive time savings and reduce debugging, syntax and logic errors. Easy to use. Build complex SQL scripts without typing any SQL. Incredibly versatile, flexible and extendible - users have complete control over the SQL that...

Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-01-25

I wish language developers would agree on the equals syntax

Today's post is short because I just want to rant about how different programming languages have different syntax for the equals sign. For some reason I've been running into this particular issue a lot the past week, and it's starting to drive me crazy.Sometimes I envy people who only...

Tags: Soapbox, Web Development, Variables, Programming, Pl/sql, Frustration

Blog posts 2007-05-16

Orbital's SQL Decryptor (zip)

Orbital's SQL Decryptor is the first product to decrypt SQL triggers, views, user defined functions, and stored procedures in an easy to use Enterprise Manager-like graphical interface. It works quickly to decrypt items in Microsoft SQL Server 6.5, 7.0, 2000, 2005 and MSDE. Orbital's SQL Decryptor allows for easy viewing...

Tags: SQL, Orbital, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-01-29

SoftTree SQL Assistant (exe)

Productivity tools for Oracle, SQL Server, Sybase, MySQL and DB2 database developers. SQL Assistant equips database developers and DBAs with the 3rd generation SQL IntelliSense and other productivity tools SQL Developers need to speed up the database development process, improve code quality and accuracy. SQL Assistant Increases SQL developer's productivity,...

Tags: Installation, SQL, SQL Assistant, SQL Assistant Add-on, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-12-25

YukonDev SQL Editor (exe)

YukonDev SQL Editor is a SQL editor and database explorer for Microsoft SQL Server. It offers syntax highlighting, in-cell editing of query results and more. The program can connect to any version of SQL Server. It enables you to explore most database items, including users, stored procedures, and indexes. Version...

Tags: Microsoft SQL Server, YukonDev SQL Editor, Storage, Databases, Hardware, Enterprise Software, Software, Data Management

Software downloads 2007-06-19

MSDN Webcast: Protecting Your System From SQL Injection Attacks - Level 200

SQL injection is one of the most serious threats a database can encounter. When an application is designed without regard for a comprehensive defense, it can provide an attack surface highly vulnerable to hackers skilled in SQL syntax. Once a hacker injects rogue SQL commands through a user interface, not...

Tags: Microsoft Developer Network, Webcast, SQL, SQL Injection, Programming Languages, Databases, Security, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Webcasts

URL Addressability in SQL Server Reporting Services - Level 300

Any report that has been deployed to SQL Server Reporting Services is available as a URL. This makes it very easy to integrate a report with an intranet or extranet site by linking from the site directly to the report. No special coding is required, just an HTML tag. In...

Tags: Report, Microsoft SQL Server, Server, Extranet, Networking, Databases, Enterprise Software, Software, Data Management

Webcasts

Ubitsoft SQL Enlight (zip)

Ubitsoft SQL Enlight is a software development tool targeted to database professionals who need to write, read and analyze Transact-SQL scripts. Ubitsoft SQL Enlight integrates with MS SQL Server 2005 Management Studio and MS Visual Studio 2005.Key features:reformat T-SQL code with set of customizable rules; summarize T-SQL script;T-SQL statements outlining;validate...

Tags: Microsoft SQL Server Transact-SQL, Ubitsoft SQL Enlight, Databases, Enterprise Software, Software, Data Management

Software downloads 2007-12-21

SQLite Manager (xpi)

Manage any SQLite database on your computer. Helpful dialogs to create tables, indexes, to browse and search the tables and the facility to execute any SQL query. A dropdown menu helps with the SQL syntax thus making writing SQL easier. This version is the first release on CNET Download.com.

Tags: SQL, Mrinal Kant, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2007-11-12

SSIS has a strange little bug with set rowcount

Last week, I described how impressed I was with my first experience using SQL Server 2005 Integration Services SSIS. Well, I've run into a quirk with the way SSIS handles certain SQL constructs. It doesn't make me change my overall impression of SSIS, but it's enough to take the bloom off the rose....

Tags: OLE DB, SQL, Microsoft SQL Server 2005 Integration Services, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management, Rex Baldazo

Blog posts 2008-02-25

ISQLme (zip)

ISQLME is TSQL Editor with lots of built-in templates. Designed to help you perform tasks on MS SQL Server databases faster without having to remember all the syntax. You can completely manage your MSDE and SQL Express databases with this tool. Includes lots of keyboard shortcuts to improve the user...

Tags: Borland Delphi, SQL, ISQLme, Programming Languages, Databases, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads 2005-10-30

tsWebEditor (exe)

tsWebEditor is a powerful PHP editor and HTML editor which you can also use as a simple text editor. It displays the source code colored syntax highlight, code hint for functions, code completion (PHP, JavaScript, ASP, HTML), code browser, PHP debugger, and syntax validation, help, CSS wizard, HTML tag editor,...

Tags: HTML, PHP, tsWebEditor, Scripting Languages, Software/Web Development, Web Development

Software downloads 2006-03-31

Avalon SQL Editor (zip)

Avalon SQL Editor is a platform-independent low-cost tool, designed for database developers. Currently, it supports: Microsoft SQL Server, Oracle, HSQLDB, MySQL, PostgreSQL, DB2, Firebird, and Derby. Supported features Database objects tables tree with their properties shown SQL Editor with syntax highlighting, code completion, word casing. Result Pane with export. Version...

Tags: Microsoft SQL Server, Avalon Team, Avalon SQL Editor, Databases, Storage, Enterprise Software, Software, Data Management, Hardware

Software downloads 2008-03-14

SQL Tools

SQLTools is a light weighted and robust tool for database development. It includes a text editor, an SQL console and a couple of SQL utilities. It can be used for dial-up connection and it will work as fast as SQLPlus. The key features include a powerful editor, which supports drag...

Tags: SQL, Tool, SQLTools, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management

Software downloads