CREATE VIEW aa AS -- 这里a1字段是一个ntext类型 select cast(a1 as Nvarchar(4000))+'dddd' as bb from tbl_temp1 GO
如果不作类型转换的话,text,ntext,image,这些类型是不可以连接的
问个可能不是sql server的问题我用sql为后端,asp为前端,像上述这种view我可否不做create view,直接在asp中写sql语句?dim rs dim strsql strsql="select cast(a1 as Nvarchar(4000))+'dddd' as bb from tbl_temp1 " set rs=createobject("adodb.recordset") rs.open strsql,conn,1,1
AS
-- 这里a1字段是一个ntext类型
select cast(a1 as Nvarchar(4000))+'dddd' as bb from tbl_temp1
GO
dim strsql
strsql="select cast(a1 as Nvarchar(4000))+'dddd' as bb from tbl_temp1 "
set rs=createobject("adodb.recordset")
rs.open strsql,conn,1,1