视图的创建和调用

[docetism]

我在mssql里创建了一个模糊查询的视图

CREATE VIEW dbo.s_xiaofei
AS
SELECT TOP 100 PERCENT ccont, cid
FROM dbo.abc
WHERE (ccont LIKE '%+@ccont+%')
ORDER BY cid

语句效果类似

select ccont from abc where ccont like '%"request("key")"%'

想请问各位，这个视图创建的对吗?
如果对的话，asp里怎样使用这个视图！

谢谢

[jacklinchen]

set conn=....
....
dim sqls
sqls="CREATE VIEW s_xiaofei as select ccont from abc where ccont like '%"request("key")"%'"
conn.execute(sqls)

视图的使用同表的使用
select * from s_xiaofei

[pzhuyy]

有参数的话,建议用存储过程.