MSSQL - 创建视图与PK
问题描述:
我创建这样MSSQL - 创建视图与PK
create VIEW [dbo].[vw_test]
AS
SELECT 'B' AS rtype, ID FROM TB_A
UNION ALL
SELECT 'V' AS rtype, ID FROM TB_B
GO
如何创建一个PK视图代码。我需要做全文搜索。 Tks
我创建这样MSSQL - 创建视图与PK
create VIEW [dbo].[vw_test]
AS
SELECT 'B' AS rtype, ID FROM TB_A
UNION ALL
SELECT 'V' AS rtype, ID FROM TB_B
GO
如何创建一个PK视图代码。我需要做全文搜索。 Tks
谢谢。我的回答没有添加任何被删除的讨论。 – Learning 2008-12-19 05:16:43