CREATE TABLE TEST(ID INT IDENTITY(1,1),COL1 NVARCHAR(20),COL2 NVARCHAR(30)) INSERT TEST(COL1,COL2)SELECT 'A','B' INSERT TEST(COL1,COL2)SELECT 'CD','EF' INSERT TEST(COL1,COL2)SELECT 'HIJ','KLMN' SELECT * FROM TEST GOCREATE VIEW V_TEST AS SELECT ID,COL1+COL2 AS COL FROM TEST GO SELECT * FROM V_TESTDROP VIEW V_TEST DROP TABLE TEST
from table?
INSERT TEST(COL1,COL2)SELECT 'A','B'
INSERT TEST(COL1,COL2)SELECT 'CD','EF'
INSERT TEST(COL1,COL2)SELECT 'HIJ','KLMN'
SELECT * FROM TEST
GOCREATE VIEW V_TEST
AS
SELECT ID,COL1+COL2 AS COL FROM TEST
GO
SELECT * FROM V_TESTDROP VIEW V_TEST
DROP TABLE TEST