FirebirdSQL/最後篇 Firebird 綜合篇/FireBird&SQLServer
出自VFP Wiki
（修訂版本間差異）
Goto-dream (對話 | 貢獻) (→參考文章) |
Goto-dream (對話 | 貢獻) |
||
| 第4行： | 第4行： | ||
原文來自Marcelo Lopez Ruiz marcelo.lopezruiz@xlnet.com.ar | 原文來自Marcelo Lopez Ruiz marcelo.lopezruiz@xlnet.com.ar | ||
| + | |||
| + | |||
===欄位型態對照表=== | ===欄位型態對照表=== | ||
| 第19行： | 第21行： | ||
| 8-byte integer type. | | 8-byte integer type. | ||
|} | |} | ||
| + | |||
| + | |||
| + | === 變數的差異 === | ||
| + | ----- | ||
| + | For example, compare the following code snippets. | ||
| + | /* This is MS SQL syntax. */ | ||
| + | CREATE PROCEDURE my_procedure | ||
| + | AS | ||
| + | DECLARE @my_variable int | ||
| + | SET @my_variable = 5 | ||
| + | /* This is FireBird syntax. */ | ||
| + | CREATE PROCEDURE my_procedure | ||
| + | AS | ||
| + | DECLARE VARIABLE my_variable int | ||
| + | BEGIN | ||
| + | my_variable = 5; | ||
| + | END | ||
| + | |||
在2005年1月26日 (三) 11:32所做的修訂版本
目錄 |
如何從Microsoft SQL Server轉換到FirebirdSQL
Microsoft SQL Server適用的版本：MS SQL 6.5, MS SQL 7 and MS SQL 2000.
原文來自Marcelo Lopez Ruiz marcelo.lopezruiz@xlnet.com.ar
欄位型態對照表
| MSSQL版本 | Data Type | Firebird | MSSQL definition and comments |
|---|---|---|---|
| 6.5 | bigint | INT64 | 8-byte integer type. |
變數的差異
For example, compare the following code snippets. /* This is MS SQL syntax. */ CREATE PROCEDURE my_procedure AS DECLARE @my_variable int SET @my_variable = 5 /* This is FireBird syntax. */ CREATE PROCEDURE my_procedure AS DECLARE VARIABLE my_variable int BEGIN my_variable = 5; END
