軟體開發

<div class="draft-block draft--p left">~~~ 從 Xuite 搬過來 ~~~</div>
<pre class="public-DraftStyleDefault-pre draft-block"><pre class="draft--code-block">-- MS SQL 沒有ORACLE 的 CREATE OR REPLACE 功能 -- 建議在 CREATE 前加下面的判斷，如果存在就刪除 IF EXISTS (SELECT 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM sysobjects &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE id = object_id('VW_HOME) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AND type = 'V') &nbsp; &nbsp;DROP VIEW&nbsp;VW_HOME GO -- CREATE VIEW CREATE VIEW&nbsp;VW_HOME AS&nbsp; ( &nbsp; &nbsp; SELECT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T1.IDNO IDNO, &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;T2.NAME NAME, &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;T1.ROLE COLLATE Chinese_PRC_CS_AS PROD_CATE ROLE &nbsp; &nbsp;&nbsp;FROM&nbsp;FAMILY T1 &nbsp; &nbsp; LEFT JOIN PEOPLE T2 ON T2.IDNO = T1.IDNO )</pre></pre>

-- MS SQL 沒有ORACLE 的 CREATE OR REPLACE 功能
-- 建議在 CREATE 前加下面的判斷，如果存在就刪除
IF EXISTS (SELECT 1
           FROM sysobjects
           WHERE id = object_id('VW_HOME)
           AND type = 'V')
   DROP VIEW VW_HOME
GO
 
-- CREATE VIEW
CREATE VIEW VW_HOME
AS 
(
    SELECT 
        T1.IDNO IDNO,
        T2.NAME NAME,
        T1.ROLE COLLATE Chinese_PRC_CS_AS PROD_CATE ROLE
    FROM FAMILY T1
    LEFT JOIN PEOPLE T2 ON T2.IDNO = T1.IDNO
)

MSSQL：CREATE VEIW 及 指定VIEW定序

MSSQL：CREATE VEIW 及指定VIEW定序