SQL Assistant equips database developers and DBAs with the productivity tools they need to speed up the database development process, improve code quality and accuracy. SQL Assistant can boost your SQL coding productivity by 300%.
Target SQL and non-SQL editors
SQL Assistant integrates with many widely used database editors and database management and development environments including native tools that come with your database systems. It provides assistance with code typing, automatic word completion and database object and attributes completion and browsing. It provides functions for quick entry of common SQL constructs and code snippets. It also provides integrated and fully interactive SQL code assistance system for instant help with SQL command syntax and options available in specific database versions, real-time code syntax checker, spell checker and a number of other vital coding tools.
SQL Assistant is fast and can be used with both very small and very large database systems. It is also very flexible and can be easily customized by users to match their coding habits.
Key Features and Benefits
* Doubles SQL developer productivity * Improves code quality and accuracy * Provides advanced SQL code intellisense features, including support for databases, objects, parameters, script variables, syntax elements and much more… * Provides interactive SQL reference and SQL code assistance systems * Provides advanced SQL code formatters and beautifiers; SQL syntax validation, code structure views for fast code navigation, and more… * Provides integrated real-time code syntax and spell checker * Supports 8 major database systems: Oracle, SQL Server, DB2, MySQL, PostgreSQL, Sybase ASE, Sybase ASA, MS Access, and their SQL dialects * Integrates with many SQL and non-SQL editors * Fast and has small disk and memory footprint * Can be easily installed without interrupting any existing processes and used immediately
Pre-configured targets:
* SQL Server Management Studio * SQL Query Analyzer * SQL Server Enterprise Manager * Visual Studio for Database Professionals (DataDude) * Visual Studio .NET/2005/2008/2010 * Visual Studio C# Express, VB Express, C++ Express, Web Developer Express * Eclipse * IBM Data Studio * Delphi * DB Tools for Oracle * PL/SQL Developer * Oracle SQL*Plus * Toad for Oracle * Toad for MySQL * Toad for DB2 * Toad for SQL Server * PowerBuilder * PostgreSQL pgAdmin III * MySQL Query Browser * MySQL Workbench * Microsoft Access * UltraEdit * Notepad++ * Notepad
Technical specifications: Disk space – 12.5 MB, Memory – 128 MB, CPU – Pentium or compatible OS – Windows 2000/XP/2003/Vista/2008/7.
Supported database systems:
* Oracle 8i, 9i, 10g, 11g * Microsoft SQL Server 2000, 2005, 2008 * DB2 UDB 7, 8, 9, 9.5 * DB2 UDB for iSeries * MySQL 5.x * Sybase ASE 12.x, 15.x * Sybase ASA 7, 8, 9, 10 * PostgreSQL 8.x * Microsoft Access 2003, 2007,2010
public static int getStrSum(String str, int start, int len) {
int result = 0;
for (int i = start; i < len; i++) {
result += Integer.parseInt(String.valueOf(str.charAt(i)));
}
return result;
}
public static int getFirstTwoLetterOfKey4() {
int rdGet = Math.abs(random.nextInt()) % 54 + 22;
return rdGet;
}
public static int getLastTwoLetterOfKey4(long value) {
String s = String.valueOf(value);
int result = 0;
for (int i = 0; i < s.length(); i++) {
result += Integer.parseInt(String.valueOf(s.charAt(i)));
}
result += 22;
return result;
}
public static String getKey2(long num) {
String result = "";
String str = xxxxxx
int base = 1073741824;
while (base > 0) {
if (num / base > 0) {
long i = num / base;
// result += i;
num = num - i * base;
char ch = str.charAt((int) i - 1);
result += Character.toUpperCase(ch);
base /= 32;
}
else {
base /= 32;
// 取个不在字符串中的字符,最简单的是取0
result += getRandomString1();
// result += "0";
continue;
}
}
return result;
}
public static String getKey0(String str1, String str2) {
int result = 0;
for (int i = 0; i < str1.length(); i++) {
result += Integer.valueOf(str1.charAt(i));
}
str1 = frontCompWithZore(result, 4, "x");
result = 0;
for (int i = 0; i < str2.length(); i++) {
result += Integer.valueOf(str2.charAt(i));
}
str2 = frontCompWithZore(result, 4, "x");
return str1 + str2;
}
public static String frontCompWithZore(int sourceDate, int formatLength,
String format) {
/*
* 0 指前面补充零 formatLength 字符总长度为 formatLength x 代表表现形式。
*/
String newString = String.format("%0" + formatLength + format,
sourceDate);
return newString.toUpperCase();
}
public static String getRandomString1() {
StringBuffer sb = new StringBuffer();
int rdGet;
char ch;
rdGet = Math.abs(random.nextInt()) % 5 + 87;
if (rdGet > 90) {
rdGet = 48;
}
ch = (char) rdGet;
sb.append(ch);
return sb.toString();
}
public static String getRandomString2() {
StringBuffer sb = new StringBuffer();
int rdGet;
char ch;
for (int i = 0; i < 2; i++) {
rdGet = Math.abs(random.nextInt()) % 28 + 65;
if (rdGet > 90) {
rdGet = Math.abs(random.nextInt()) % 10 + 48;
}
ch = (char) rdGet;
sb.append(ch);
}