创建一视图,
CREATE VIEW dbo.VIEW2
AS
SELECT column1, NULL as column2 , NULL AS column3, NULL as column4
FROM dbo.AYiping2
现在我想控制column2到column4的列类型,该如何修改该视图,谢谢
CREATE VIEW dbo.VIEW2
AS
SELECT column1, NULL as column2 , NULL AS column3, NULL as column4
FROM dbo.AYiping2
现在我想控制column2到column4的列类型,该如何修改该视图,谢谢
FROM dbo.AYiping2把几个空设为列干嘛?
在CREATE VIEW dbo.VIEW2下面设置类型应该可以吧
CREATE VIEW dbo.VIEW2
(
自己设置类型
)