创建视图时如何包含命名空间和模式绑定？

Question

你会如何包括SCHEMABINDING随着XMLNAMESPACES

CREATE View [dbo].[GetSomething] As 

WITH XMLNAMESPACES ('http://www.something.com/some.xsd' AS gev) 

-- How to include SCHEMABINDING-- 

SELECT 

Answer 1

CREATE VIEW dbo.Something WITH SCHEMABINDING AS 

WITH XMLNAMESPACES 

Answer 2

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