4.1.33 ( return). goto. RETURN_PROFILE(' '), return.
4.1.34 ANSI- (left join, inner join), . 4.3.10. *= =*.
4.1.35 ( sql), .
4.1.36 union , , .
4.1.37 (grant all) _GRANT_ALL_TABLE_. view.
4.1.38 null. isnull(<>, < >), is null is not null.
4.1.39 DCL_PROC_BEGIN
4.1.40 <> as '<>'.
4.1.41 ( 0), 1, 2 . , retcode.sql
4.1.42 trim().
() ltrim() rtrim() , NOT NULL (- MSSQL Sybase).
.
select @s = isnull(ltrim(@s), ′′) select @s = trim(@s) select @s = isnull(ltrim(rtrim(@s)), ′′) | select @s = rtrim(@s) select @s = ltrim(rtrim(@s)) |
4.1.43 ( ) #- M_FORCEORDER M_KEEPPLAN. ( !). , p-, , M_KEEPPLAN .
:
, - - , , MS SQL Server "", , ( ), . , . #- p-. , , , .. , , : , , KEEPFIXED PLAN , .
|
|
4.1.44 drop table #.... , MS SQL Server. , , , , .
4.1.45 ( Seed ..) , .