資料指標(CURSOR)
Execute Dynamic SQL commands in SQL Server
圖片擷自 Devart 官方網站 |
參賽者
|
SQL Complete
(Express Version) |
SQL Pretty Printer
|
智慧感知功能
Smart Intellisense
|
V
|
X
|
提供表格物件名稱
Name suggestions for major objects |
V
|
X
|
提供函式名稱
Name suggestions for advanced objects |
部份提供
Partial Support |
X
|
智慧篩選清單
Smart filtering in the suggestion list |
V
|
X
|
輸入關鍵字後的內容建議
Context-sensitive suggestion of keywords |
部份提供
Partial Support |
X
|
資料庫名稱建議功能
Database context detection |
V
|
X
|
依照SELECT, DML, DROP,
EXEC, SET和 USE 語法的上下文提供建議清單
Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements |
V
|
X
|
提供函式所需參數種類及數量
Parameter information for functions |
V
|
X
|
快捷物件資訊(如表格所含的欄位及格式內容)
Quick object information |
部份提供
Partial Support |
X
|
SQL 格式化處理
SQL formatting |
部份提供
Partial Support |
V
|
執行當前語法
Execute current statement |
V
|
依賴SSMS
內建功能 Dependent SSMS
Built-in features
|
半透明的訊息箱
Semi-transparent view of the suggestion box |
V
|
X
|
提供的SQL文字組譯成各種語法
(SQL to c#, Dephi, C++ string etc) |
X
|
V
|
提供各語法轉成標準SQL語言
(Any language to SQL) |
X
|
V
|
Single License Price
($$$)
|
Free
|
$50
|
CREATE TABLE DAILY_PRODUCT_SALES (
DATE_OF_SALE DATE NOT NULL,
PRODUCT_ID INTEGER NOT NULL,
UNITS_SOLD INTEGER NOT NULL CHECK (UNITS_SOLD >= 0),
CONSTRAINT UNIQUE_DAILY_SALES
PRIMARY KEY (DATE_OF_SALE, PRODUCT_ID)
);
How to list all tables in a database?
In MySQL, you can do SHOW TABLES. You can use the same in Firebird's isql command-line tool, but nowhere else. However, this can be done by querying Firebird's system tables:
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS;
This query will show you both system and user tables. To select user tables only, use this:
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0;
Note for advanced users:
The above query will select both user tables and views. To select tables only use this:
SELECT RDB$RELATION_NAME FROM RDB$RELATIONS WHERE RDB$SYSTEM_FLAG = 0 AND RDB$VIEW_BLR IS NULL;
有看不懂的…再寫個意見給我吧。