CREATE VIEW [policy] AS SELECT [dbo].[article].[newsid], [dbo].[article].[title], [dbo].[article].[N_Fname], [dbo].[article].[path], [dbo].[article].[content] FROM [dbo].[article] go select * from [dbo].[article] where typeid in (select kindid from newskind where parentid=169)
CREATE VIEW [policy] select * from [dbo].[article] where typeid in (select kindid from newskind where parentid=169)
AS SELECT [dbo].[article].[newsid], [dbo].[article].[title], [dbo].[article].[N_Fname], [dbo].[article].[path], [dbo].[article].[content]
FROM [dbo].[article]
go
select * from [dbo].[article] where typeid in (select kindid from newskind where parentid=169)
select * from [dbo].[article] where typeid in (select kindid from newskind where parentid=169)