sqlserver-创建视图时,如何包含命名空间和架构绑定



如何将SCHEMABINDING与XMLNAMESPACES 一起包含

CREATE View [dbo].[GetSomething] As
WITH XMLNAMESPACES ( 'http://www.something.com/some.xsd' AS gev)
-- How to include SCHEMABINDING--
SELECT 
CREATE View [dbo].[GetSomething] 
WITH SCHEMABINDING
AS
WITH XMLNAMESPACES ( 'http://www.something.com/some.xsd' AS gev)
SELECT -- Make sure your select follows the rules for schemabinding of course
CREATE VIEW dbo.Something WITH SCHEMABINDING AS 
WITH XMLNAMESPACES

最新更新