Features:

Table Report - Quickly bring printable info about a table
Tabbed Windows - VS.NET style editor windows
User Functions - see what user functions are in your databases
Stop Button - allowing you to stop execution of an SQL statement (finally!)
System Functions - displayed in database explorer. This is quite handy.

Sql Primary Key Constraints


July 16, 2008   SQL — Tags: , , — 52coding   

Primary key is the term used to identify one or more columns in a table that make a row of data unique. Although the primary key typically consists of one column in a table, more than one column can comprise the primary key. For example, either the employee’s Social Security number or an assigned employee identification number is the logical primary key for an employee table.

聽1.Scrawlr
https://download.spidynamics.com/Products/scrawlr
Microsoft and HP co-developed聽 tools, will be the site of reptiles, string enquiries all the pages of analysis and SQL INJECTION found that the risk. Scrawlr part of HP WebInspect use the same technology, but only detected SQL INJECTION risk. Scrawlr from a starting URL entrance, climbed over the whole site, and all of the pages in the site for analysis to find loopholes that may exist.

What Is Data?


July 7, 2008   SQL — Tags: , , — 52coding   

Data is a collection of information stored in a database as one of several different data types. Data includes names, numbers, dollar amounts, text, graphics, decimals, figures, calculations, summarization, and just about anything else you can possibly imagine. Data can be stored in uppercase, lowercase, or mixed case. Data can be manipulated or changed; most data does not remain static for its lifetime.

Some Popular Relational Database Vendors


July 7, 2008   SQL — Tags: , — 52coding   

Some of the most predominant database vendors include Oracle, Microsoft, Informix, Sybase, and IBM. These vendors distribute various versions of the relational database for a significant cost. There are many other vendors who supply an open source version of an SQL database (relational database).

Ineeded to convert existing SQL Server databases to SQLite databases as part of DB migration program and did not find any decent free converter to do the job. my attempt to solve the problem. I should warn you though that I did not have much time to test it on too many databases. In any case - the source code is very well documented and easy to understand .

What Is SQL?


July 6, 2008   SQL — Tags: , , — 52coding   

SQL, Structured Query Language, is the standard language used to communicate with a relational database. The prototype was originally developed by IBM using Dr. E.F. Codd’s paper (”A Relational Model of Data for Large Shared Data Banks”) as a model. In 1979, not long after IBM’s prototype, the first SQL product, ORACLE, was released by Relational Software, Incorporated (it was later renamed Oracle Corporation).

Page 1 of 11