Y yutao728 Unregistered / Unconfirmed GUEST, unregistred user! 2002-01-07 #1 怎么SELECT SQL-SERVER 中的视 给个例子！！！
T taozhiyu Unregistered / Unconfirmed GUEST, unregistred user! 2002-01-07 #3 select field from talbe where field = 'value'
Y yutao728 Unregistered / Unconfirmed GUEST, unregistred user! 2002-01-07 #5 在SQL-SERVER2000数据库中创建一个视图，然后在DELPHI6中怎么查询这个视图？？？ 能看明白吗？？
S snjat Unregistered / Unconfirmed GUEST, unregistred user! 2002-01-07 #6 CREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0) select * from syssegments
CREATE VIEW syssegments (segment, name, status) AS SELECT 0, 'system' , 0 UNION SELECT 1, 'default' , 1 UNION SELECT 2, 'logsegment' , 0) select * from syssegments
W westboy2000 Unregistered / Unconfirmed GUEST, unregistred user! 2002-01-07 #10 视图的使用方法跟表的使用方法是一样的，只不过只能查询，不能新增和修改。
A Alix Unregistered / Unconfirmed GUEST, unregistred user! 2002-01-07 #11 通过视图也可以新增和修改table呀，这是sql2000的一个trigger新特性
