1select * from test1
2select * from test
3
4insert into test1 values ('a')
5
6alter view tstView
7
8as
9
10select distinct T.[Name],T.[No] from test T,test t1 where T.[name] = t1.[name]
11
12 
13
14select * from tstview
15
16insert into tstview ([name],[no]) values('fd',18)
17