Open source SQL Client in C#:SQL Buddy
August 11, 2008 Open source, Sql Server — Tags: .net open source, free Sql client, SQL, SQL Client, Sql Server — 52coding
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.
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.
SQL Injection attack detection tools
July 8, 2008 SQL — Tags: SQL, SQL Injection, SQL Injection check, Sql Server — 52coding
聽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.
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: Relational Database, SQL — 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).
SQL Server DataBase Convert to SQLite DataBase
July 6, 2008 Sql Server — Tags: SQL, Sql Server, sql server2005, sqllite, sqlserver2000 — 52coding
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 .
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).

